Power BI Weekly
Issue #273 - 27th August 2024
It's that time again - the Power BI August 2024 Feature Summary has been released. It's not huge (as has generally been the case since Fabric was released) but we now have a few cool updates, including a Data Limit for visuals to help mitigate potential performance issues (Reza Rad has described this feature in greater depth in the video Power BI Report Performance Tip Add Data Limit), and also Visual level format strings are now in preview, giving you an extra level of customization of visual level calculations (which the Learning Science channel has expanded on in the video Power BI visual level calculation formatting option). Elsewhere this week, Daan Oosters has shared a great (public) Power BI report to help track available admin settings in the blog No control over new tenant settings? Here's how to take back control, and Alberto Ferrari is back explaining one of the DAX fundamental principles Filter columns, not tables, in DAX.
🛠️ Data Prep
- On the Power BI community blog, Ignacio Barrau (@ignacho_07) describes how to Transform column with custom condition
- Sunil Mathew (@_sunil_mathew_) describes how to Import Local Images into Power BI Power BI Tutorial
- Chandeep Chhabra (@chandeep2786) writes about Advanced Unpivoting Tricks in Power Query
- Avi Singh (@powerbipro) writes about an Advanced Power Query Merge in Power BI: The Range Merge with No Exact Match
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) describes how to Use Power Query Parameters to Make Power BI and Fabric ETL Dynamic
- Rick de Groot (@Rickmaurinus) describes how to Concatenate values in Power Query M | Avoid these pitfalls!
- Lars Schreiber (@SchreiberLars) shares 5 Produktivitätstipps für die Arbeit mit breiten Tabellen [German]
- Ben Richardson (@AcuityTraining) describes Understanding Merge Queries & Append Queries
🧩 Data Modeling
- Chris Webb (@cwebb_bi) covers Tuning Power BI Copilot With Row Labels And Key Columns
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes how to Filter columns, not tables, in DAX
- Bas Dohmen (@HowToPowerBI) shares some Power BI Parameter Tricks
- Sunil Mathew (@_sunil_mathew_) writes about Dynamic Top N & Bottom N with proper Sorting using RANKX
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) shares Power BI Report Performance Tip Add Data Limit
- On the Learning Science YouTube channel, Learning Science (@learn_scitech) talks about the Power BI visual level calculation formatting option
📊 Report Authoring and Interactivity
- Meagan Longoria (@mmarie) writes Comparing Power BI Core Visual and Deneb Stacked Column Chart
- Martin Schoombee (@MartinSchoombee) writes Rate my dashboard
- Reid Havens (@HavensBI) talks about Conditional Formatting Integrated Bar Upgrades
- On the Learning Science YouTube channel, Learning Science describes How to copy a part of Microsoft Power BI matrix visual data into Excel or CSV files
- Andrzej Leszkiewicz (@avatorl) writes “This is my First Dashboard. Review it.”
🚀 Deployment, Security and Operations
- Daan Oosters (@daanoosters) writes No control over new tenant settings? Here's how to take back control
- Gilbert Quevauvilliers (@GilbertQue) covers Downloading Scanner API data using a Microsoft Fabric Notebook
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) talks about Dynamic Row Level Security in Power BI with Manager Level Access
- On the phData blog, Manikanta Gudivaka (@phdatainc) delves into Enabling Dynamic Report Subscriptions in Power BI
- On the Power BI blog, Nikki Waghani (@NikkiWaghani) highlights the On-premises data gateway August 2024 release
- On the endjin blog, James Broome (@jamesbroome_) explains How to ensure quality and avoid inaccuracies in your data insights
🌐 General
- On the Power BI blog, Jason Himmelstein (@jasehimm) shares the Power BI August 2024 Feature Summary
- Reid Havens (@HavensBI) discusses Building an Analytics Team with Reza Rad