Power BI Weekly
Issue #172 - 30th August 2022
A packed edition this week, and haven't we been spoilt. On the "official Power BI announcements" front, we've finally got a feature many of us have been waiting for for years - Announcing Public Preview of Multiple Audiences for Power BI Apps! This enables you to distribute different subsets of your artifacts within a workspace to different "audiences", effectively equivalent to multiple apps per workspace. This is big - I can imagine many admins will be happy about the possibility to declutter their tenant of now-redundant duplicate workspaces. We've also been told about the Updates to Microsoft Purview data loss prevention policies in Power BI, including CPU metering for data loss prevention policy evaluation.
On the non-official announcement front, but still very much official in my eyes, is the really exciting announcement that DAX Studio v3 has been released! You can read about the details in Darren's article here: v3 Release, Marco's article here: DAX Studio 3 released, and Marco's live recording with Adam and Patrick over here: DAX Studio 3 is out! LIVE w/ Marco Russo (Aug 27, 2022). Amazing work by Darren and the SQLBI team - thank you! Finally, and continuing from last week, I wanted to highlight Jeffrey's next blog about the brand new EVALUATEANDLOG function, all about Understanding The Output of EvaluateAndLog Function of Table Expressions.
🛠️ Data Prep
- Jonathan Law covers A deep dive into Power BI incremental refresh feature
- Marcus Wegener (@PowerBIler) shares the recording from the Power BI – UK User Group: Exploring the Power BI Datamarts
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) hosts Incremental Refresh and Hybrid Tables in Power BI by Shabnam Watson (Auckland Power BI User Group)
- Ruth Pozuelo Martinez (@CurbalEN) describes a New way of Dealing with errors in Power Query
- On the RADACAD blog, Leila Etaati (@leila_etaati) writes about Azure Machine Learning Call API from Power Query
- James Andrew (@MatadorSoftware) describes how to Simply Create a Summary Table in Power Query
- Lars Schreiber (@SchreiberLars) covers Tabellenüberschriften massenhaft und dynamisch umbenennen mit Power Query [German]
- Soheil Bakhshi (@biinsightnz) writes about Slowly Changing Dimension (SCD) in Power BI, Part 2, Implementing SCD 1
🧩 Data Modeling
- Darren Gosbell (@darrengosbell) announces DAX Studio v3 released
- On the SQLBI blog, Marco Russo (@marcorus) announces DAX Studio 3 released
- Also on the SQLBI blog, Marco Russo (@marcorus) talks about Expanded Table – The Whiteboard #04 and talks about VertiPaq Analyzer crash course
- Adam Saxton and Patrick Leblanc (@GuyInACube) talk about DAX Studio 3 is out! LIVE w/ Marco Russo (Aug 27, 2022)
- Jeffrey Wang (@jwang_pbi) explains how to Understand the Output of EvaluateAndLog Function of Scalar Expressions and explains how to Understand The Output of EvaluateAndLog Function of Table Expressions
- Chris Webb (@cwebb_bi) writes about Why I’m Excited About The New DAX EvaluateAndLog() Function
- On the Enterprise DNA blog, Antriksh Sharma (@AntrikshShar) delves into DAX Query In Power BI: Understanding Its Logical Flow and blogs about Format DAX Codes Using DAX Studio's Special Features
- Matt Allington (@ExceleratorBI) talks about Introduction to Power BI and DAX
- On the Power BI community blog, Eason Fang describes how to Calculate the working days between two dates excluding weekends and holidays
- On the Tessellation Tech blog, Nabila Mohamed describes How to Create a Bridge Table in Power BI
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes DEFINE COLUMN – DAX Guide and describes DAX 101: Using RELATED and RELATEDTABLE in DAX
- Max Wikström (@maxwiks) writes about Inside Power BI – Compression and the power of Vertipaq and covers Level up your Power BI model using DAX Studio – Part 1
- Bernat Agulló Roselló (@AgulloBernat) describes Building a fading bar chart
- Chandeep Chhabra (@chandeep2786) describes Custom Data Labels in Power BI
- Arnaud Gastelblum (@LazySna1l) covers Power BI Sidetools extensions: A Must Have
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) discusses Power BI and Excel Integration
📊 Report Authoring and Interactivity
- Patrick Leblanc (@GuyInACube) discusses Slicers vs. Slicer Pane vs. Filter Pane! Which is faster? and explains how to Simulate Hierarchies with Field Parameters in Power BI
- Brian Julius (@_EnterpriseDNA) describes How To Quickly Add Dynamic SVG Visuals To Your Power BI Report
- On the Enterprise DNA blog, Sue Bayes (@sue_bayes) describes Paginated Report In Power BI: An Introduction
- Bas Dohmen (@HowToPowerBI) describes The Ultimate Slicer Panel in Power BI
- Lars Schreiber (@SchreiberLars) describes Wie Du in Power BI Leerwerte in Datenschnitten verhinderst [German]
- Reid Havens (@HavensBI) describes Customized Bar Chart Using a Matrix Visual + Conditional Formatting (with Gustaw Dudek)
- On the Learning Science YouTube channel, Learning Science describes Bookmarks for Selected Visual in Power BI
- On the Bridge All blog, Ryan Chatham writes about New Power BI metric & scorecard features
- Andrzej Leszkiewicz (@avatorl) discusses Map with Pie Charts?
- Sam McKay (@_EnterpriseDNA) covers Field Parameters Combined With Small Multiples In Power BI - An Amazing Combination and highlights Get Inspired By These Excellent Power BI Examples - Innovative Techniques And Cool Features
- Philipp Lenz (@lenz_philipp) covers Power BI and Visio
- Daniel Marsh-Patrick (@the_d_mp) provides A Study on Hills and Valleys in Power BI with Deneb
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) describes Tips to improve Power BI report appeal
🚀 Deployment, Security and Operations
- On the Power BI blog, Yael Biss (@MSPowerBI) announces Updates to Microsoft Purview data loss prevention policies in Power BI
- Also on the Power BI blog, Harleen Kaur announces Announcing Public Preview of Multiple Audiences for Power BI Apps
- Chris Webb (@cwebb_bi) walks through Calling The Power BI Enhanced Refresh API From Power Automate, Part 4: Getting The Status Of a Refresh
- Ted Pattison (@TedPattison) presents Power BI Dev Camp Session 25 - Modern React-JS Development with Power BI Embedding
- Gilbert Quevauvilliers (@GilbertQue) explains How to add External (B2B) users’ access to Power BI reports
- On the Tessellation Tech blog, Spencer Baucke (@JSBaucke) explains How to Provision Access to Power BI Workspaces and Licensing and describes Enabling Azure AD SSO in Snowflake with Power BI
- Marc Lelijveld (@MarcLelijveld) explains How to add DTAP stage identifiers of to your Power BI report with Smart Narratives
- Dan English (@denglishbi) blogs about Power BI Data Driven Subscriptions with Power Automate (Report Bursting)
🌐 General
- Alex Powers (@notaboutthecell) announces Join members of Power BI CAT at the Power Platform Conference
- On the MSSQLTips site, Scott Murray blogs about Development Best Practices for Power BI
- James Andrew (@MatadorSoftware) talks about What is Power BI? Why Should You Learn It In 2022?