Often I got the question from customers: "Can you assign my workspace to a premium capacity?" But frequently they actually do not really need Power BI Premium. It remains to be a difficult topic to decide whether someone needs Power BI Premium or not. Therefore, I decided to setup a decision tree that helps to …
On to the next topic, which is super important for global, enterprise grade solutions if you ask me. Security and information protection! The fifth blog in the series of transforming local into global Power BI solutions. Good to know up front is that information protection is a feature that not specifically related to Power BI, …
Continue reading Transform a local into a global Power BI solution – Information protection
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
A decent data model is the key to success in Power BI. As this an underexposed topic in the end-to-end story of Power BI, Jeroen ter Heerdt (Program Manager on the Power BI team) and I believed it is time to change this! Wednesday, 17th of March, the first episode in a series of webinars …
Continue reading Webinar Data Modeling 101: Increasing the impact of Power BI
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
I strongly believe that it is key to describe everything that you have built as part of your Power BI model. As we all have a hate-love relationship with documenting our work, the external tool that I build to document your Power BI solutions could come in useful. In particular everything you add and only …
Continue reading Add descriptions for everything you create in Power BI!
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
Time fore new enhancements to the Power BI model Documenter tool! I just presented the new enhanced version of the Power BI model Documenter at the Dutch Power BI User group. Soon, there will also be a recording online of the presentation that I will add to this post as soon as it is available. …
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 …
Data - Marc 