Microsoft Power BI
We’re at a point where the way we work with data is fundamentally shifting. Natural language is becoming the new interface, and tools like Microsoft Fabric are making it possible to ask questions and get answers straight from your data. One of the latest updates allow connecting Data Agents (formerly known as AI Skills) directly …
Continue reading Natural Language Interaction Isn’t Magic—It’s Semantic Modeling Done Right
Last week I was running a post-conference (postcon) workshop at Fabric February in Oslo. To have a successful postcon, workspaces were needed for all attendees of the workshop. In these workspaces they had to run their exercises and explore Fabric. But setting up a bunch of workspaces by hand, assigning it to a capacity and …
Continue reading Behind the Scenes: How I Automated My Fabric Workshop (training)
Yes, you read it right. Most security implementations on data estates are a joke. It's just closing your eyes for what you can't see or don't feel responsible for. Too often I come across situations where the lack of security awareness and proper implementation results in locking the front door but leaving the back door …
A long time ago, I blogged about Power BI governance with topics like feature implementation in a phased approach and why you should consider to disable export to Excel. In this blog, I want to continue the governance topic with another blog about why monitoring your tenant is important! This blog will also provide you …
Imagine you have a semantic model in the Power BI Service (or Fabric if you will), and you're about to make a breaking change to this semantic model. How do you inform your end users? How do you tell them about this change? In this blog I will zoom in to options you have in …
Continue reading Full Impact Analysis in Power BI, Export and Analyze in Excel
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
There are tons of options in Power BI to add your custom logic. Varying from SQL expressions at data ingest all the way up to Visual Calculations to add logic on a visual level. But how do they compare to each other, where should you do what? As I've been a fan of making DAX …
Continue reading Comparing calculation options in Power BI, including Visual Calculations
Recently, I wrote a blog about the new branch-out feature in Git connected Fabric and Power BI workspaces. In this blog, I will continue the topic of Git integration by discussing various setups you could consider in your Git integration, deployment and release strategies as part of your continuous integration and continuous delivery setup. Will …
Continue reading Fabric CI/CD with Git deployment and release strategies
I've heard the question pretty often from customers: "You told me to use incremental refresh, but how can I regularly run a full load or refresh onder partitions?" Well, there are perfect ways to do this using Tabular Editor or SQL Server Management Studio. But this often includes manual work to trigger the processing. Today, …
It has been roughly two years since the last update on the Power BI Model Documenter, an external tool that I developed to auto-document Power BI Semantic Models. Back then, we still called it datasets though. Looking at the stats of my website, the model documenter and related posts/pages are still most read on my …
Continue reading Improving Semantic Model Documentation with AI in Power BI
Data - Marc 