Power BI > The magical BLANK row in table

We all know how the basic components in Power BI should work. But as soon as you think that now you have reached the stage where you know almost all about Power BI, it leaves you open-mouthed. Recently, I came across a very weird issue – “A BLANK row getting added to the Table from nowhere”… Continue reading Power BI > The magical BLANK row in table

Power BI > How to fetch Dynamics 365 CE data

Power BI provides several different ways to fetch data from Dynamics 365 CE and today I will share my know-how on them. 1. Dynamics 365 Online Connector This method is mostly used to fetch data from Dynamics 365 CE. Initially, this was the only method to fetch data from CE. To use this, go to Get… Continue reading Power BI > How to fetch Dynamics 365 CE data

Power BI > Dynamic Scales & Values

Hello DAX-sters! We have already created a report where we can choose what data we can show – dynamically. You can refer to the blog here. How about we get the freedom to choose even how the data can be shown, i.e. weekly, monthly, quarterly, or yearly? Every so often we need the availability of… Continue reading Power BI > Dynamic Scales & Values

Power BI > Size limits to consider while choosing the right capacity

Many of us often face difficulties understanding the dataset size limits in different scenarios and different capacities. So, here is a quick understanding of the same. Different type of capacities: 1. Shared Capacity 2. Premium Capacity 3. Azure Power BI Embedded Capacity Power BI provides either Shared Capacity or Premium Capacity. Power BI, by default,… Continue reading Power BI > Size limits to consider while choosing the right capacity

Power BI > Sharepoint Online List as Data Source

Power BI has been growing day by day with the new features that the Power BI team is bringing every month. One of the great features for those who are working with Sharepoint Online is that we can use “Sharepoint Online” List as a data source in Power BI to get an overview about Sharepoint… Continue reading Power BI > Sharepoint Online List as Data Source

Power BI > Copy Visuals between pbix files – II

Power BI has been growing day by day with the new features that Power BI team is bringing every month. There was a time when we used to face difficulty whenever it was needed to create same designing for multiple reports but with different datasets, because we couldn’t just copy paste the visual from one… Continue reading Power BI > Copy Visuals between pbix files – II

Power BI > Conditional Formatting the Table > Use Case

Microsoft has released a very exciting feature – Conditional formatting by Field Value. Hence, we plan to explain how we took it’s best use with an example. There are times when we want to conditionally format a field that returns both text values and decimal numbers. To understand this better, let’s take some sample data… Continue reading Power BI > Conditional Formatting the Table > Use Case

Power BI > Hide NULL or BLANK values in Matrix visual

There are times when you don’t want null values to be displayed in the matrix, or only those items which has data in the table in Power BI. Suppose we have data as in the below image: And we want those names which has all the three types, S1, S2 and S3. Simply plotting the… Continue reading Power BI > Hide NULL or BLANK values in Matrix visual

Power BI > Copy visuals to another pbix file

After using Microsoft Power BI Desktop after so long, there is one very basic feature we feel missing , i.e. we can’t copy or move any visual from one Power BI desktop file to another file. Microsoft Power BI Desktop does not provide this feature, however we can achieve this by using Power BI Service.… Continue reading Power BI > Copy visuals to another pbix file

Power BI > Plotting Dynamic Values

Hello DAX-sters! Have you ever wanted to show data as per your choice in a visual, i.e. you get the freedom to choose whether you want to plot the data of Order/Sales, or Profit/Loss. There is no custom visual which gives you an option to choose what value you want to show. There is a… Continue reading Power BI > Plotting Dynamic Values

Importance Of Microsoft Power BI And How Can It Help A Business?

Business Intelligence is one of the latest buzzwords that appear in the top trends in the businesses. As a result, a number of businesses have started exploring new business intelligence solutions like Microsoft Power BI offered by the Microsoft Power BI consultants India. But what Microsoft Power BI actually is and how it is powerful… Continue reading Importance Of Microsoft Power BI And How Can It Help A Business?