Share your Power BI dataset and spice up your table and column names

Imagine that you are building a Power BI dataset for corporate reporting, that will also be reused for self-service purposes by many others. It is up to you, as dataset author, to make it as simple as possible for them to reuse your content and avoid misunderstandings. In this blog I will give more detail …

Continue reading Share your Power BI dataset and spice up your table and column names

Power BI drill through, powerful, but hard to find, Until now!

The drill through functionality is in Power BI for a long time and already made huge steps forward. Though, one of the most challenging things with this very valuable feature was the discoverability. Hidden behind the right-click, not every user was able to use this feature or not even know that it is there. Let me take you through the biggest game-changers for drill through in Power BI and close-off with the recently launched (preview) feature in the March 2020 release!

Data:Scotland – Make AI available for everyone!

Last week, on Friday Septembre 13th, I presented at Data:Scotland. As the name already suggests, in Scotland, Glasgow to be precise. An awesome community event with loads of intresting people and reality well organized. Definitely one to put on your list to visit once! At this event, I presented my all new session about "AI …

Continue reading Data:Scotland – Make AI available for everyone!

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!

Dynamic object titles in Power BI!

Posting a blog on Sunday, yeah...why not. This time posted from the beautiful city of Stockholm. I traveled to Stockholm to attend SQL Saturday Stockholm #851 this weekend as a speaker. Today, Sunday, I'm still here to do some sight seeing. So I wrote this blog post with the below shown view. Could be worse... …

Continue reading Dynamic object titles in Power BI!

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

Dynamically expanding and appending tables with Power Query

It has been a month since my last blog post. So, it was about time for new content! Since last month I'm busy preparing for the Power Platform Summit at the end of March in Amsterdam, so not much time left. Find more about the summit on my events page. So far so good, now time …

Continue reading Dynamically expanding and appending tables with Power Query

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 …

Continue reading Move from single to a multi-file strategy