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!
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
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!
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... …
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 …
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
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
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 …
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 …
Continue reading Format your colors based on Advanced Controls
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 …
Data - Marc 