Power BI Weekly
Issue #231 - 31st October 2023
No Power BI-specific announcements this week, but one that's closely related on the Fabric side is the release of Data Activator in Public Preview. This feature allows you to create alerts on standard Power BI report visuals when they meet a certain pattern or condition, and then take action correspondingly - either by sending emails/Teams messages, or hooking up to a custom Power Automate flow. See Tom Martens' blog on this for a real example: Select, Detect, Act, or why I consider Reflex being a watchdog or check out the polished Microsoft Mechanics video on the topic, presented by Will Thompson: Automate data-driven actions | Data Activator in Microsoft Fabric. Sticking to the Fabric-Power BI theme, Sandeep Pawar has shared a new tool: Measure Maze: Visualizing Measure Dependencies Using Semantic Link & Network Analysis, providing an insight into the dependency trees of the measures in your Power BI dataset using the new SemPy
package under the covers. And for those that rely on Power BI's integration with Log Analytics, Chris Webb has highlighted the New HostProperties Data In The ApplicationContext Column In Power BI Log Analytics which allows you to retrieve information about the consumption method via which report consumers have been viewing the report (e.g. Power BI Web App, Power BI Teams Personal App). Quite useful if you're wanting to understand how/where people are consuming certain reports!
Final reminder that I'm presenting at the Oxford Microsoft Data Platform Group tomorrow evening at 18:30 GMT, showcasing an End-to-End Solution in Microsoft Fabric for Data Engineers. Hope to see you there!
🛠️ Data Prep
- On the Power BI community blog, Ignacio Barrau (@ignacho_07) discusses [PowerQuery] Catch errors in a request http
- Rick de Groot (@Rickmaurinus) describes Date Formatting in Power Query – Master 18 Custom Formats, writes about Understanding Expression Syntax Errors in Power Query M and describes Mastering Custom Format Strings in Power Query M
- Chandeep Chhabra (@chandeep2786) describes Power Query Trick Add Multiple Columns in 1 Go and provides A Big Announcement & 5 Advanced Data Cleanup Examples in Power Query
- On the Select Distinct blog, Simon Harrison (@SelectDistLtd) writes about When to transform data for Power BI?
🧩 Data Modeling
- Sandeep Pawar (@PawarBI) discusses Measure Maze: Visualizing Measure Dependencies Using Semantic Link & Network Analysis
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) covers Optimizing callbacks in a SUMX iterator
- Kurt Buhler (@kurtbuhler) describes Case-sensitive models in Power BI: consequences & considerations
- Patrick Leblanc (@GuyInACube) covers Mind-Blowing Power BI Update: Model View enhancements
- Reid Havens (@HavensBI) describes Exploring the New Semantic Model View + Native Calculation Groups and talks about New & Upcoming Features for Measure Killer (with Gregor Brunner)
- On the Learning Science YouTube channel, Learning Science describes how to Change the measure in Power BI based on different slicer value selections | HasOneValue in DAX
📊 Report Authoring and Interactivity
- On the Power BI community blog, Alexander Grekov (@barritown) writes about Custom Captions on Axis X
- On the phData blog, Gavin Pedersen (@gavin_PD) blogs about Power BI Slicers vs. Filters: The Difference and When to Use Them
- Bas Dohmen (@HowToPowerBI) describes Building SVG Charts in Power BI and explains how to Improve UI with Animated Arrows for Power BI Report
- On the MSSQLTips site, Kenneth A. Omorodion (@mssqltips) explains How to Make Power BI Reports More Useful for End Users
🚀 Deployment, Security and Operations
- Chris Webb (@cwebb_bi) writes about New HostProperties Data In The ApplicationContext Column In Power BI Log Analytics
- Patrick Leblanc (@GuyInACube) talks about The Secret to Data-Driven Dynamic Subscriptions in Paginated Reports
- Gilbert Quevauvilliers (@GilbertQue) explains How to schedule a Power BI dataset refresh to start at the exact time you want it to start
- On the Purple Frog Systems blog, Tom Owen (@PurpleFrogSys) blogs about Introduction to Power BI Project Files
- On the phData blog, Gavin Pedersen (@gavin_PD) explains How to Create Power BI Deployment Pipelines
- Tom Martens (@tommartens68) writes about Power BI Gateway monitoring and more using Microsoft Fabric and writes Select, Detect, Act, or why I consider Reflex being a watchdog
🌐 General
- Adam Saxton and Patrick Leblanc (@GuyInACube) present Microsoft Fabric / Power BI Q&A w/ Marco Russo LIVE (October 28, 2023)
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 263 - Power BI August 2023 Feature Summary, Episode 264 - Interview with Heather Cook, Episode 265 - Power BI September 2023 Feature Summary and Power Platform Conference Wrapup and Episode 266 - Power BI October 2023 Feature Summary
- Matthew Roche talks about Becoming a data fencing master