MSBI Tutor

DAX user-defined functions are now production-ready based on community feedback and internal validation. Their adoption during preview shows that DAX UDFs are quickly becoming a mainstay of Power BI semantic models. Reusable, discoverable DAX building blocks Now, DAX user-defined functions are ready to support production models at scale. With DAX UDFs, you can write a calculation once and reuse it across measures, columns, and visuals — instead of copying the same expression into multiple places and hoping they stay in sync. You can use /// documentation comments to make your functions self-describing — type a function name and IntelliSense shows the function description and the signature. Type hints control parameter passing behavior and enforce type safety at runtime.   You can break large monolithic DAX expressions into small, testable pieces that are easier to read, debug, and share with your team. And perhaps best of all, because DAX UDFs are first-class model objects with typ...

Power BI tenant migrations have shifted from a niche topic to a regular field conversation, usually triggered by an acquisition, divestment, data residency requirement, or overdue modernisation. This post complements the official Microsoft Learn documentation on Power BI tenant migration patterns and strategies . While the documentation covers the end-to-end process, this post focuses on how to decide if a tenant migration is the right choice—and the trade-offs to evaluate before committing. Across most customer engagements, one principle seems to hold true: tenant migration is typically a trade-off between potential gains and added complexity. This post covers common triggers, migration types, key risks, and scenarios where the benefits may justify the effort. The goal is to help you weigh that trade-off before the project gathers momentum of its own Why we are seeing more tenant migration requests Over the past year, there has been an uptick in tenant migration conversations. Most fa...

Getting data is the starting point of almost every Power BI workflow. It’s where users connect to their data, explore what’s available, and begin shaping it for analysis. As a joint effort between the Data Integration and Power BI teams, we are introducing the Preview of the new Power Query Get Data experience in Power BI Desktop —a completely redesigned way to help you discover and connect to your data faster.  Why we built a new Get Data experience? Over time, the number of connectors and data sources in Power BI has grown significantly. While this brings flexibility, it also introduces friction—especially when users are trying to quickly find the right data source or understand how to get started. At the same time, we’ve been evolving Power Query across Fabric experiences. This created an opportunity to rethink the Get Data flow end-to-end and align experiences across Desktop, Fabric, and beyond. The result is a modernized experience built on three key principles: Faster discove...