The Power BI team has invested a lot over the past year in making datasets better discoverable in the Power BI Service. This helps on many aspects to drive a data culture within your organization, aim for a single source of truth, collaboration within the organization and much more! In this blog post I will …
Continue reading Transform a local into a global Power BI solution – Introduction
Back in 2019, Ton Swart and I wrote a blog post on Versioning and CI/CD for Power BI with Azure DevOps. Back then, there were not many options available for versioning and professionalizing your ALM story for Power BI. Till today, this blog post is still my most read blog on Data-Marc.com which makes us …
Continue reading Integrate Power BI Deployment Pipelines with Azure DevOps
It is very common to have multiple reports for different audiences, while there is also one (group of) user(s) that requires to have an overview over all these different insights. The main challenge you will face, is having cross-report interactivity and find related insights. Let's take an example of three different roles, where we have …
Continue reading Jump from one Power BI report to another by using cross-report drill through
If you want to refresh a Power BI dataset, we all know where to find the refresh button in Power BI Desktop as well as in the Power BI Service. By clicking it, you will trigger the entire dataset to refresh. But sometimes it is more convenient to trigger a single table to refresh. If …
Continue reading Trigger a single table to refresh in the Power BI Service
In the Power BI service, you can easily look at refresh times for an individual dataset or dataflow. There are many different reasons why these metrics are important to you as a dataset or dataflow owner. For example, you may bump into refresh time-outs or unfortunate errors. There are many good reasons to think about …
Continue reading Extract refresh metrics for your entire Power BI workspace
Over a year ago, I wrote a blog about moving dataflows across workspaces using a PowerShell script. Especially useful if you want to move dataflow logic from your development to test, acceptance or production workspace. I received a bunch of feedback on this script and run into some issues myself as well lately. It was …
Recently, I run into a case where we wanted to combine Direct Query sources with imported data. Well, this functionality is actually called composite models nowadays. Having that said, let me start with managing some expectations for this post. The title says composite models, but I have to admit, it is not about the to …
Continue reading Will query folding apply to Power BI Composite models?
At Microsoft Ignite, there were two really exciting announcements when it comes to enterprise features for Power BI. Both directly took my attention, as well as for many others. Obviously, the first one is Power BI Premium per user (PPU) licensing. Secondly, Deployment Pipelines reached General Availability! Two super important features for enterprises and the …
Continue reading Leverage Power BI Deployment Pipelines with Premium per user licensing
Getting more insights in the telemetry of your Power BI dataset is always interesting. Especially if you share your Power BI dataset for self-service purposes to build new reports on top of your managed dataset, you might want to know who is actually using in and what queries are they executing against your datasets. Besides …
Continue reading Analyze active sessions and cancel refreshes in Power BI
It is only a week ago when I posted the icon library for diagrams.net, also known as draw.io, wrote a blog about it and shared with all of you. Now it is already time to give it the first update! At Ignite 2020, Microsoft showed us the new Power Platform Icons for the very first …
Continue reading [UPDATED] Power BI icon for Diagrams.net to draft full Power Platform Solutions
Data - Marc 