Partially Loading A Dataflow
Incremental refresh is a great feature in Power BI for Datasets and Dataflows, to greatly reduce refresh times and reduce the load on the source system. However, all the data/partitions are loaded at the same time at creation…
Read More »Updated – Get SharePoint List Data … Fast
While storing your data in a database is recommended, many citizen developers do not have the access or skills to create databases. As a result, many valuable business solutions are based on top of SharePoint Lists, and all…
Read More »Time Tables in Power BI
In a previous video, the importance and benefits of splitting DateTime columns into separate Date and Time columns was discussed. For example, a table with DateTime columns of StartDateTime and StopDateTime should be transformed in the query editor…
Read More »Calculate and Format Durations in DAX
An important thing to know about dates and times in Power BI (and Excel PowerPivot) is that they are really just integers and decimals, respectively, behind the scenes. All dates and times in Power BI are relative to…
Read More »Easily Create and Modify Custom Functions in Power BI
Custom functions are a great feature available in the query editor (Power BI or Excel), and allow you to simplify your code and/or re-use it to save time across multiple files/models. Power BI provides the Combine & Transform…
Read More »445 Calendar with 53-Week Years
Many businesses operate on a standard calendar so that each fiscal week/month/year begin and end on the same day of the week, making YOY comparisons easier. A 445 calendar is one example, in which each quarter is comprised…
Read More »No Sort Date Tables!
We've all been there. You go to create your visual with Months on the axis and you see April, August, December … and realize you forgot to create Sort By columns. One way around that is to use…
Read More »Get Data From SharePoint Lists … But Fast
Note: A better approach is described in a more recent post. The new version allows for Scheduled Refresh in the Power BI Service, and avoids the issue described in the comments below with duplicate items. See new post…
Read More »March Madness With Dataverse For Teams
A few years ago, I wrote a March Madness article on PowerPivotPro that used Excel as the data source (here). With the NCAA tournament being hosted in Indianapolis this year, I decided to revisit that post and make…
Read More »Template Files are an Under-Sung Feature
Power BI allows individuals to build solutions that can increase productivity and generate new insights for entire organizations. Usually that's done through publishing models/reports/dashboards to the Power BI service, which provides a secure, flexible, and powerful platform. Another…
Read More »