Updated – Get SharePoint List Data … Fast

No Picture

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

No Picture

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

No Picture

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

No Picture

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

No Picture

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!

No Picture

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

No Picture

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

No Picture

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 »

Save time with a starter file

If you make lots of Power BI data models and aren't already doing it, a good practice is to make a starter file to use for new models instead of starting from scratch each time.  Although it is…

Read More »