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…

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…

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…

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…

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…

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…

Multi-tier architecture and continuous delivery with Power BI

We live in a busy and stressful era. In our daily business we can not wait for weeks, months or even longer to get our insights. So we need to deliver faster. Therefor we are working agile to realize continuous delivery of results. The agile approach helps us to deliver small artifacts to the end-user…

The new Power BI Home experience

In a growing popularity of Power BI, the content within Power BI is growing exponentially as well. With that, it is harder to find your favorite content within the Power BI service. Therefor the Power BI team introduced the option to mark items as a favorite with which you can create a sub-selection of your…

Welcome!

Thanks for visiting my new site! On this site, I will post  blogs about data and artificial intelligence related topics. In the near future most blog topics will be related to Power BI, since this is my core business. On long term topics will be in a wider range of Microsoft Data & AI related…