Power BI Weekly
Issue #269 - 30th July 2024
Welcome to the 269th edition of Power BI Weekly! No announcements this week. On the community front, here are my highlighted bits of content: Marco Russo has followed up on last month's Filter Context article with the complementary blog Row context in DAX explained visually and Romain Casteres has written about (and shared some great resources for) Monitoring Power BI Semantics Models over time. And now a couple of interesting webinars for you this week: Stephanie Bruno has joined Mike Carlo to explore the Power of Semantic Link, and Elena Drakulevska has joined Reid Havens to speak about where Power BI Meets UX Design: Accessible Insights.
Finally, this week we're very excited to share our new and improved powerbiweekly.info and azureweekly.info websites, marking the 10th year and 5th year anniversaries of the two newsletters! The sites come with updated branding, more easily navigable archives, and search functionality to find articles over historical editions. Both sites come with RSS feeds if you prefer consuming content that way: see Power BI Weekly RSS and Azure Weekly RSS. As ever, we'll be publishing the content on our @PowerBIWeekly and @AzureWeekly X handles, but we'll also start to publish our content on Bluesky soon too: see @powerbiweekly.endj.in and @azureweekly.endj.in. Please take a look at the new sites and let us know if you have any feedback!
🛠️ Data Prep
- Reid Havens (@HavensBI) talks about Not All Query Folding is Created Equal...Performance Tuning PQ (with Greg Baldini)
- On myOnlineTraininghub, Mynda Treacy (@OnlineTrainingH) writes about Excel Data Cleaning Shortcuts
- Lars Schreiber (@SchreiberLars) shares Ergebnisspalte bei flexibler Anzahl von Wertspalten erzeugen Power Query [German]
🧩 Data Modeling
- On the SQLBI blog, Marco Russo (@marcorus) announces Contoso Data Generator v2 and talks about Row context in DAX explained visually
- On the Business Intelligist blog, Nikil Prabhakar wonders Is Copilot in Power BI getting better?
- On the Power BI community blog, Tharun Kumar Ravikrindhi describes How to update Power BI measures in bulk
- On the MSSQLTips site, Harris Amjad (@mssqltips) explains how to Write Logical Expressions using DAX with Power BI Operators and Functions
- On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) walks through Exploring the Power of Semantic Link with Stephanie Bruno
📊 Report Authoring and Interactivity
- Adam Saxton (@GuyInACube) writes about Happy little accidents with the Power BI Card Visual
- Madison Giammaria shares a Hierarchical Gantt Chart in Deneb
- Reid Havens (@HavensBI) covers Power BI Meets UX Design: Accessible Insights (Elena Drakulevska)
- Sunil Mathew (@sunomath7) discusses Gradient Donut in Power BI using SVG Native Visual
- Chandeep Chhabra (@chandeep2786) shares Highlight Sales Drops - Creative Line Chart Visualization in Power BI
- On the Learning Science YouTube channel, Learning Science talks about When to mark Date Dimension table as a date table in Power BI
- Andrzej Leszkiewicz (@avatorl) shares opinions on Dark Themes for Business Reports?
🚀 Deployment, Security and Operations
- Chris Webb (@cwebb_bi) talks about Power BI Refresh, Memory Usage And Semantic Model Scale Out
- On the Purple Frog Systems blog, Callum Bryant (@PurpleFrogSys) blogs about Power BI Dataset Gives Mashup Timeout Error While Refreshing
- Romain Casteres (@PulsWeb) describes Monitoring Power BI Semantics Models over time