Featured

Versioning and CI/CD for Power BI with Azure DevOps

Over a year ago, I wrote a  blog about Multiple tier architecture and continuous delivery with Power BI, mainly an overview of the setup and manually creating development and production content. This blog will continue this story in more detail of Power BI CI/CD with Azure DevOps automated deployments. A solution where Dave Ruijter, Ton …

Continue reading Versioning and CI/CD for Power BI with Azure DevOps

Move dataflows across workspaces with the Power BI REST API

Dataflows are part of the Power BI service for a while now. More and more people are starting to benefit from it in multiple perspectives. The two most heard ones are re-use of data (and logic), but also isolate refreshes to avoid dependencies of refresh failures from different sources.Same as for your data sources, you …

Continue reading Move dataflows across workspaces with the Power BI REST API

Don’t let date columns ruin query folding in Power BI

Previously, I've written a blog post about Top N & query folding to improve report building. In this blog post I explained how query folding groups Power Query steps together and execute at the data source. Matt Allington also wrote a great blog with further explanation on how query folding works. While working on projects, …

Continue reading Don’t let date columns ruin query folding in Power BI

Inform your end-users by embedding dataflow refresh times in your Power BI reports

It has been a month since my last blog. Busy times with a lot of interesting projects, so less time for writing blogs. Last weekend I was traveling to Power Saturday in Paris. So now I finally had some time to write the blog I was thinking about for a while. Dataflows! Power BI dataflows …

Continue reading Inform your end-users by embedding dataflow refresh times in your Power BI reports

Top N & query folding to improve report building!

Another week, another event done. This time it was SQL Saturday Helsinki, where I did two sessions. First session was the Power BI cheat sheet explained, and second Storytelling & interactive reporting, one of my favorite sessions to do. Today, another day in Helsinki, but since the weather isn’t that good, it is time for …

Continue reading Top N & query folding to improve report building!

Pimp the dataflows connector in Power BI

Last week, I was challenged by moving my Power BI dataset through the next stage in my DTAP pipeline. I simply wanted to re-assign my connections to the data source in the next stage. In my case, I created a separate workspace including separate dataflows for each stage. Since de dataflows connector in Power BI is …

Continue reading Pimp the dataflows connector in Power BI

Power Platform Summit & Power BI gebruikersdag

Last week I attended at two events, the Power Platform Summit and the Power BI gebruikersdag (Power BI Saturday). During these events I presented multiple sessions on different topics. First of all, I would like to thank the program committee for selecting my sessions. In addition, I also want to thank everybody who attended at …

Continue reading Power Platform Summit & Power BI gebruikersdag