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…

Dynamic object titles in Power BI!

Do you want to change titels of your Power BI objects dynamically? It’s possible now! Read all about it in my blog post, posted from the beautiful city of Stockholm!

Pimp the dataflows connector in Power BI

Re-assign your dataflows connections without rebuilding your dataflow? Pimp the dataflow connector in Power BI to make it easier to switch! Read all about it in my blog!

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…

Move from single to a multi-file strategy

In some cases, you might want to split your report and data model into separate Power BI Desktop files. For example, to work in together on the same content or create multiple reports based on the same dataset. There can be many reasons to do this. But once you started building everything one file, you don’t want to do a lot of rework to split it up. What to do to avoid rework and split it up?

Embed your Power BI Content!

Microsoft rolled out a new embedding feature for Power BI content. Next to the already known features as Embed in SharePoint Online, Publish to Web and Power BI Embedded, there is a new feature available now! Power BI Secure Embedding allows you to embed your content to client applications or sites while maintaining all security in your reports. In this blog I will write down a short summary of all available embed features available in Power BI.

Format your colors based on Advanced Controls

Power BI is the (best) data visualization tool of Microsoft. But how to apply your color formatting to your visuals without changing it by hand for every visual separately, which is an option of course, but in case you will get a next category in your visual, you have to manually add this to your…

Parameterize your data source!

The first step we take in every Power BI report, is connecting to the data source. But maybe you have to change your data source after a while. For example when your transferring your solution from development to acceptance or production. Of course, we can switch data source in the data source settings of our Power…