After a short holiday break, it is time for a new blog post! This time about one of the most exciting functionalities in Power BI that has been released in the past release wave, Power BI Deployment Pipelines! In this blog I will elaborate on what Power BI Deployment Pipelines are, why it is an …
Continue reading Why you should care about Power BI Deployment Pipelines
In my previous blog, I wrote about using Tabular Editor to migrate existing (Azure) Analysis Services models to a Power BI data model. This is pretty awesome already! Once you moved your model to Power BI, you can also start using the functionality of the entire platform. One of the most useful features is dataflows …
Continue reading Bring existing tables to Power BI dataflows with Tabular Editor
Over the last two weeks, I had the pleasure to work on an innovative case where we wanted to migrate on premises Analysis Services models to a Power BI Premium data model. Definitely an interesting case! Because of this project I finally found some decent time to investigate XMLA endpoints for Power BI Premium! In …
Continue reading Migrate Analysis Services models to Power BI using Tabular Editor
In this blog I describe a few of the challenges you might face when you have a lot of dataflows. I will describe a few tips and tricks I am applying to sanitize your dataflow approach, organize dataflows and easy to browse through. Dataflows are increasingly used as shared resource or staging layer inside the …
Continue reading How to keep your Power BI dataflows organized and optimized
The Power BI team releases many new features in every monthly release, which is an amazing achievement to make it happen every time. Having all this new functionality on your fingertips is a great experience, but not all functionality is production ready yet. Every now and then, functionality is in public preview, which means that …
Continue reading Power BI Governance – New functionality? Govern the implementation in phases
Let's start this blog with a scenario. I think all of us, who are a (Power) BI professional, have been in this situation... Once you start a new project, you gain all the requirements for a newly to be created report, interview a representative group of users and you start building the report. After a …
Recently, I posted a poll on Twitter to vote for new blog topics. One thing that popped-up in my mind, was more on the governance side of Power BI. A topic where I spend a lot of my day-to-day time, but is maybe less interesting for others? At least that is what I thought. Below …
Continue reading Power BI Governance – Why you should consider to disable Export to Excel
Lately, I published the first out of two blogs about monitoring your on-premises data gateway. The first blog was all about monitoring your gateway up time but doesn't tell you when one of the connections on your gateway is down. This blog will go in more detail how you can monitor your data source connectivity …
Power BI includes a very rich set of data connectors to get your data from. Both connectors to on-premises and cloud solutions are provided which sometimes require an On-premises data gateway in order to refresh your dataset in the Power BI service. This additional component, does not have out-of-the box monitoring functionality. But why not …
As a Data & Analytics consultant, working on tons of different projects, it is very likely that I'm the creator and owner of a whole lot of dataflow and dataset refreshes. Since these refreshes can only be managed by the owner, this limits the rest of my colleagues from updating the scheduled and maintaining the …
Continue reading Manage all your Power BI refreshes in one place with Power Automate (Flow)
