Bring existing tables to Power BI dataflows with Tabular Editor

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

Migrate Analysis Services models to Power BI using 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

Personalize your Power BI page navigation

Back in January 2020, I visited the Power BI Days in Belgium, where I had a talk about custom page navigation in Power BI. I already started playing around with the Power BI REST API and URLs to create a personalized navigation. As other bloggers might recognize, I ended-up as a draft blog but I …

Continue reading Personalize your Power BI page navigation

Leverage Azure Cognitive Services in Power BI without Premium subscription

Recently, I was presenting my session about AI Capabilities for Power BI to make AI Accessible for Everyone for the Virtual Power BI Days Hamburg. A great event organized by Kathrin Borchert. Part of my session was about the Artificial Intelligence capabilities offered as part of Power BI Premium. A day later, Kathrin came up …

Continue reading Leverage Azure Cognitive Services in Power BI without Premium subscription

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

Monitor your On-premises data gateway with Azure and Power BI – Part 2 – Data source connectivity

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 …

Continue reading Monitor your On-premises data gateway with Azure and Power BI – Part 2 – Data source connectivity

Monitor your On-premises data gateway with Azure and Power BI – Part 1 – Gateway up-time

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 …

Continue reading Monitor your On-premises data gateway with Azure and Power BI – Part 1 – Gateway up-time

Thumbs up or down? Measure Power BI report sentiment with MS Power Automate (MS Flow)

As Power BI enthusiasts and consultants, we are building tons of reports. All with the goal to enable the business to take data driven decisions by providing them with the right information at the right time. Though, if your reporting audience is growing, there is no way to satisfy all your users. Of course, the …

Continue reading Thumbs up or down? Measure Power BI report sentiment with MS Power Automate (MS Flow)

Versioning and CI/CD for Power BI with Azure DevOps

Over a year ago, I wrote a  blog about Multiple tier architecture and continuous delivery with Power BI, mainly an overview of the setup and manually creating development and production content. This blog will continue this story in more detail of Power BI CI/CD with Azure DevOps automated deployments. A solution where Dave Ruijter, Ton …

Continue reading Versioning and CI/CD for Power BI with Azure DevOps

Move dataflows across workspaces with the Power BI REST API

Dataflows are part of the Power BI service for a while now. More and more people are starting to benefit from it in multiple perspectives. The two most heard ones are re-use of data (and logic), but also isolate refreshes to avoid dependencies of refresh failures from different sources.Same as for your data sources, you …

Continue reading Move dataflows across workspaces with the Power BI REST API