Have you ever wanted to sync two slicers on a report page? Even when both slicers are coming from different dimensions? A lot of users end up setting the relationships to bi-directional (both) which has huge side effects! You may up with a ambiguous data model, over filtering fact tables and wrong results. Also, there …
Continue reading Sync two slicers without bi-directional relationships in Power BI
Another blog post based on recent client experiences. Last week, I visited a client where we had extensive discussions on data model optimization. As you might know, data modeling in Power BI is one of my favorite topics, so I had an excellent day. It's also not the first time that I blog about anything …
Continue reading The Hidden Impact of Keys in Your Power BI Data Model
Discussions with clients regarding the performance of their data models in Power BI have been a frequent occurrence for me recently. The issues often involve failed refreshes, queries that run slowly, or models that do not meet the clients' expectations. In most cases, I begin by asking a standard set of questions before diving into …
Continue reading From Frustration to Optimization: A Journey through Power BI Data Model Design
Recently, I've published a new version of the Model Documenter. With that, version 2.1.0 went live. I always try to keep the FAQ up to date and add sections describing typical questions and use cases. However, sometimes it is just easier to write a blog about it to reach a bigger audience, or even record …
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
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?
Back in 2020, I released the first version of the Power BI external tool to document your Power BI data model. Since then, I wrote a lot about this topic, such as why adding descriptions to everything is important and various releases of the model documenter. Users encountered various challenges with the initial release of …
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
Data - Marc 