Power BI Weekly
Issue #270 - 6th August 2024
After the lull in announcements, this week they're back with a bang. First of all, we've been told about the general availability of Tabular Model Definition Language (TMDL) - a huge milestone for programmatic data model authoring, and one that has been many years in the making. Well done to all those involved in making this happen. Sticking to the data modeling theme, we've been given a Deep dive into DAX query view for web - that's right, "for web". You can now write DAX queries in an editor in the Power BI Service, which is very cool! Although let's not forget about the tools that have helped us get where we are today - Darren Gosbell has shared the DAX Studio v3.1.0 Release with a number of new features, fixes and improvements. Outside of DAX/modeling, we've been told about the new (preview) paginated report authoring experience, again, directly in the Power BI Service. Nice work!
On the community articles this week, I must start by issuing a correction on last week's editorial, where I attributed the Monitoring Power BI Semantics Models over time article to Madison Giammaria instead of Romain Casteres, who actual wrote the article (thanks Madison for pointing that out). In fact, Romain is back again this week with another article about Generating a Date Dimension Table for Direct Lake Model in Microsoft Fabric - a great script to have at your disposal if you're generating your star schema using Python. Elsewhere this week, Bernat Agulló Roselló is back with the start of a fascinating in-depth series about "Transforming a regular report into a bilingual one", writing Part 1: Extracting Titles, Subtitles, and Textboxes and Part 2: Extracting Display Names of Measures and Field Parameters, and Teo Lachev has written an interesting article sharing his thoughts on Power BI and Fabric Capacities: Thinking Outside the Box.
🛠️ Data Prep
- Bernat Agulló Roselló (@AgulloBernat) writes about Transforming a regular report into a bilingual one Part 1: Extracting Titles, Subtitles, and Textboxes and Part 2: Extracting Display Names of Measures and Field Prameters
- Rick de Groot (@Rickmaurinus) explains how to Make your Group By Operations Dynamic in Power Query M
- On the Power BI community blog, Melissa de Korte (@enterprisednaco) writes about To Delete or Keep Columns? That's the Question.
🧩 Data Modeling
- On the Power BI blog, Rui Romano (@RuiRomano) covers Announcing general availability of Tabular Model Definition Language (TMDL)
- Also on the Power BI blog, Zoe Douglas (@MSPowerBI) writes about Deep dive into DAX query view for web
- Darren Gosbell (@darrengosbell) delves into DAX Studio v3.1.0 Release
- Romain Casteres (@PulsWeb) demonstrates Generating a Date Dimension Table for Direct Lake Model in Microsoft Fabric
- Avi Singh (@powerbipro) shares a Power BI Data Modeling Guide for Beginners
- Shivanshu Bisht writes about Dynamic Currency Formatting (Indian Rupee)
- On the Learning Science YouTube channel, Learning Science describes how to Format Boolean value 0 or 1 according to your choice in Power BI
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) talks about 12 Time Intelligence DAX Functions for Excel OR Microsoft Power BI, describes How to Calculate Cumulative SUM or Running Total in Microsoft Power BI - DAX, talks about Dynamic Current and Previous Year Balances up to a Certain Date - Power BI DAX and describes Dynamic TopN + Others in Microsoft Power BI
📊 Report Authoring and Interactivity
- On the Power BI blog, Nirupama Srinivasan (@MSPowerBI) highlights the New paginated report authoring experience (Preview)
- Roland Szirmai (@BILAnalytics) talks about Creating Impactful Top N vs Others Visualizations using Power BI - Workout Wednesday Special
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) explains How to Create (Show or Hide) Pop-Up Menu Or Slicers Panel in Power BI - Bookmarks & Buttons
- Chandeep Chhabra (@chandeep2786) shares how to Highlight Sales Drops - Creative Line Chart Visualization in Power BI
🚀 Deployment, Security and Operations
- On the Prologika blog, Teo Lachev (@tlachev) blogs about Power BI and Fabric Capacities: Thinking Outside the Box
- Chris Webb (@cwebb_bi) writes about Power BI DirectQuery, Gateways And SQL Queries That Return Lots Of Rows
🌐 General
- Vahid Doustimajd (@VahidDoustiM) presents Microsoft Fabric & Power BI Q&A - Reza Rad [Persian]
- On the Power BI Tips and Tricks blog, the Explicit Measures podcast team (@PowerBITips) covers Overcoming Challenges in the Center of Excellence