Power BI Weekly

Welcome to the 366th edition of Power BI Weekly! No official announcements from the Power BI team this week, but on the Fabric updates blog, we've been told about the VNET Data Gateway Autoscaling (now in Preview) which dynamically adjusts active nodes based on workload demand to balance performance and costs within administrator-defined limits. Now onto the community content:

Kurt Buhler has written about how to write good descriptions for semantic model columns and measures, arguing descriptions are now first-class metadata rather than optional hygiene. In particular, Kurt makes the point that a description written for the benefit of Copilot is often a bad description for a human hovering over a measure, so write each one with a specific audience in mind.

Moving on, there are a few of these this week, but Reza Rad has a video demoing no-code Power BI report authoring using GitHub Copilot, the Fabric Skills Report Authoring skill, and the Power BI Desktop Bridge, building a full report from natural language prompts alone (benefiting from the new Fabric Skills and Power BI Desktop Bridge tooling. Both of which are relatively hot-off-the-press, but definitely worth experimenting with.

My colleague James Broome has laid out workspace topology patterns for Microsoft Fabric, from a single workspace through to full medallion-layer splits (including separating Reporting workspaces from Data Engineering workspaces), along with the tipping points that push you from one to the next. And on the DAX/reporting side, Marco Russo has published a piece on dynamic formatting by hierarchy level using ISINSCOPE and ISATLEVEL, applying different colour logic to a matrix visual by year, quarter, or month.

Finally, Chris Webb has written up the benefits of using Direct Lake mode in Power BI: faster, cheaper refreshes, no more memory or timeout limits, and reuse of the same OneLake data across models and engines. But there are plenty of caveats that are noted in both Chris' and others' related blogs. Also, take a read of the comments section - some interesting points that complement the core blog content.