Solutions 1: Convert Time Zones – FORMAT Even if your SharePoint site’s regional settings are correct (or whichever data source you’re pulling from), Power BI could convert it to the wrong time zone upon import. It’s a quick fix, luckily. Instead of using your “modified,” “created” or other date fields in your report, we’ll create Read More
Category: Power BI
How to Export a Table from Power BI Desktop to Excel
There are some ways to export Power BI Desktop data in Excel. You can copy the entire table, including all DAX calculated columns, very easily and paste it on a destination like Excel. This way is good for a small volume of data. Go to Date View and select the table you want to export, select Copy Table and then paste it in Read More
How to Use Unpivot Columns and Pivot Columns with Examples
Unpivot columns Unpivoting is a useful feature of Power BI. You can use this feature with data from any data source, but you would most often use it when importing data from Excel. The following example shows a sample Excel document with sales data. Though the data might initially make sense, it would be difficult to Read More
How to Use a Non-active Relationship in Power BI – USERELATIONSHIP
Another DAX function that allows you to override the default behavior is USERELATIONSHIP. Consider the following data model example. The preceding screenshot shows an established relationship between the Date and OrderDate columns, as shown by the highlighted line connecting the two. The solid line between the two tables indicates that it is the active relationship, meaning that by default, Read More
How to Improve Data Quality in Power BI
Column quality, Column distribution, and Column profile In this blog, you will understand all about Power BI Data profiling tools (Column quality, Column distribution & Column profile). The data profiling tools provide you with a visual way to understand more about your data. Using this you can clean, transform, and understand data in Power Query Editor. Column Read More
Power BI Quick Reference: Import vs Direct Query
Microsoft Power BI is a self-service Business Intelligence tool that lets you connect to multiple different data sources – Power BI offers 92 different data connectors to connect the data sources. With these connectors, you can connect to different data sources. Power BI offers two different Data Connectivity modes to connect the data sources – Import Read More