Power BI Weekly
Issue #264 - 25th June 2024
No technical announcements this week, but Microsoft has yet again (unsurprisingly) been named a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics and BI Platforms, being placed in the most impressive position (and by some distance)! Well done to the various teams at Microsoft.
Onto the community blogs this week: Meagan Longoria has written a great blog about What to Know about Power BI Theme Colors, Marco Russo has shown Filter context in DAX explained visually (for you spatial learners out there), and Marc Lelijveld has written a much needed blog about Power BI and Fabric capacities: Understand the difference and cost structure.
🛠️ Data Prep
- Rick de Groot (@Rickmaurinus) writes about Dynamic Group By Operations in Power Query M and talks about Extracting Year, Month, or Day from a Date in Power Query
- On the Learning Science YouTube channel, Learning Science explains How to combine multiple row values into a single cell in Power Query using Power BI
- On the Power BI community blog, Sam Kumar (@inogic) explains how to Utilize Power BI Semantic Model within Power BI Reports Builder
- Jeff Lenning (@Exceluniversity) explains how to Automate File Cleanup
🧩 Data Modeling
- On the SQLBI blog, Marco Russo (@marcorus) blogs about Filter context in DAX explained visually
- Mark Walter (@markwaltercpa) shares some Chapter Notes: The Definitive Guide to DAX
- Reid Havens (@HavensBI) hosts Power BI Performance Tuning: Why is my report slow now? With Eugene Meidinger
- Roland Szirmai (@BILAnalytics) explains how to Automate Last Day Slicer in Power BI - Easy Field Parameters Tutorial
📊 Report Authoring and Interactivity
- On the Business Intelligist blog, Nikil Prabhakar writes about Step-by-Step Guide to the Best Planning and Forecasting Visual in Power BI
- Meagan Longoria (@mmarie) writes about What to Know about Power BI Theme Colors
- Chandeep Chhabra (@chandeep2786) describes How to Create Outstanding Power BI Reports
🚀 Deployment, Security and Operations
- Marc Lelijveld (@MarcLelijveld) delves into Power BI and Fabric capacities: Understand the difference and cost structure
- Laura Graham-Brown (@Laura_GB) explains how to Allow the use of Power BI Rest APIs and talks about Power Automate – Create the Power BI Workspace
- Chris Webb (@cwebb_bi) blogs about Power BI Semantic Model Memory Errors, Part 4: The Query Memory Limit
- On the Power BI blog, Nikki Waghani (@NikkiWaghani) shares the On-premises data gateway June 2024 release
🌐 General
- On the Power BI blog, Kim Manis (@kimmanis) highlights that Microsoft named a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics and BI Platforms