What you must know when building Power BI dataflows routing over the on-premises data gateway

Another week, another challenge! Summer holidays is the perfect time to run into challenges that you normally would not encounter or simply do not know about because they are fixed before you know. This blog will elaborate on a case I had at a client, where we run into issues with the on-premises data gateway …

Continue reading What you must know when building Power BI dataflows routing over the on-premises data gateway

Add user to Power BI deployment pipeline using REST APIs

Especially in this time of the year, you will encounter many similar kind of questions as a Power BI Service Administrator. Questions like: "My colleague is on vacation, but I don't have access to the workspace and the refresh broke, can you help me getting access to this workspace?" Well, this is still the simple …

Continue reading Add user to Power BI deployment pipeline using REST APIs

Nomination as Dutch IT Talent – vote for me!

This time a slightly different post. Not Power BI or Microsoft related. Though I would like to ask you to read on cause I need your help! I'm proud to announce that I'm nominated as Dutch IT Talent of the year 2022 by Computable. Cause with only the nomination I'm not there yet. Now, I …

Continue reading Nomination as Dutch IT Talent – vote for me!

Power BI B2B External Collaboration

You might have seen the recent YouTube video by Guy in a Cube, where Adam explains how to work as an external user and publish content from Power BI Desktop to a B2B workspace. In this blog, I will further elaborate on business-to-business capabilities of Power BI, some related tenant settings that allows or blocks …

Continue reading Power BI B2B External Collaboration

Successfully implementing Power BI composite models

Have you been working with Composite Models in Power BI? Did you run into challenges while you did? Then this blog is for you! In this blog I will further elaborate on what the composite models (including DirectQuery for Power BI datasets) are and everything that comes into play when you start implementing them. During …

Continue reading Successfully implementing Power BI composite models

Sharing individual Power BI dataflows, but how?

Recently, I have had a challenge at a customer, where a central teams maintains many dataflows in Power BI, to store their only and single version of the truth. However, this central team maintained many different dataflows in a single workspace, but did not want to share the entire workspace with others. What now? How …

Continue reading Sharing individual Power BI dataflows, but how?

Resources and recap of SQL Bits

Last week, I had the pleasure to meet up with the amazing community again in London at SQL Bits. As very first thing, I want to express my appreciation and gratitude to those who were in the organizing team for SQL Bits for making this all happen! Such a large event in difficult times like …

Continue reading Resources and recap of SQL Bits

Script and automate Power BI Backup operations

Basically for every data model, but in particular for large and enterprise-grade data models, it might be wishful to perform backups. Power BI Premium offers a way to perform backup and restore operations for Power BI datasets. This feature, coming from Azure Analysis Services, helps you to take a backup of your dataset logic as …

Continue reading Script and automate Power BI Backup operations

Power BI Workspace setup – Part 2

After Power BI Workspace setup - part 1, which was mainly about creating your workspace, giving it the right name etcetera, this blog will elaborate on workspace permissions. If you did not read part 1 yet, I encourage you to start at that blog to get the basic setup in place. You might think, permissions …

Continue reading Power BI Workspace setup – Part 2

Power BI Workspace setup – Part 1

Time for a more governance related blog this time. It will be a series of two blogs, where in this first part, I will elaborate on the overall setup of your Power BI workspace and naming. The second part will continue about workspace permissions, sharing and ownership. I feel this is a wide topic and …

Continue reading Power BI Workspace setup – Part 1