Power BI Weekly
Issue #165 - 12th July 2022
First of all, congratulations to all those that received the MVP award in the last week, and thank you for all the effort you all put in for the sake of the Power BI Community - it doesn't go unnoticed! This week we've had a couple of updates, the first of which is the Improved Power BI Experience in Excel, which includes a nicer search experience when finding datasets to connect to, and some additional deep links into Power BI artifacts associated with the datasets. The other update is a new Power BI Mobile feature called Data in space, which allows you to "create spatial anchors in the real world and attach Power BI data to them, so that data can be connected to the physical environment it describes." This is one of those features that probably has a very niche market, but is nonetheless a pretty mind-blowing feature to witness as a Power BI enthusiast.
Elsewhere this week, there have been a few interesting videos. First of all, the next episode of the Power BI Community Show aired on Monday, covering Power BI, Dynamics 365 & Dataverse (a popular trio right now), Mohammad Ali (Group Program Manager at MSFT) has joined Reid Havens to discuss The Future of Power BI which is well worth a watch, including a live Q&A with the audience (discussing topics like Desktop Hardening, Bookmarks, 2-year plans etc), and finally Ted Pattison has hosted another Dev Camp call discussing Power BI Dev Camp Session 23 - Developing for Power BI using Azure Functions, showing the power of integration Azure services with Power BI in your solutions.
🛠️ Data Prep
- Ben Gribaudo (@bgribaudo) describes Custom Connectors: Introducing Table.ViewError & Terminal Errors
- Chris Webb (@cwebb_bi) blogs about Gateways And Measuring Power Query CPU Usage During Power BI Dataset Refresh
- On the Power BI community blog, Vijay Verma describes Power Query - Methods to Refer to Previous Row - Time Performance Comparison to determine the Best
- James Andrew (@MatadorSoftware) explains how to Apply Inventory Level Ranking in Power Query | Index Columns, Group By & Aggregation
- Rick de Groot (@Rickmaurinus) describes how to Extract Dates From Text Strings in Power Query
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) describes Power BI Report Builder Parameters Tutorial
- Olivier Travers (@otravers) covers Creating Cross-Database SQL Views via Stored Procedure from Power BI – Wait What?
- Ruth Pozuelo Martinez (@CurbalEN) describes how to Track all your social media channels easily in Power BI | Social media tracker template included
- Lars Schreiber (@SchreiberLars) covers So Verteilst du Monatswerte Linear auf Tage [German]
🧩 Data Modeling
- On the SQLBI blog, Marco Russo (@marcorus) covers Hiding measures by using object level security in Power BI
- On the endjin blog, Jessica Hill (@JessRoseHill_) describes CALCULATE in DAX
- Antriksh Sharma (@AntrikshShar) blogs about Performance penalty of Measures in Filters Pane in Power BI, on the Enterprise DNA blog, covers Storage Engine – Its Role In Optimizing DAX Queries in Power BI and explains how to Configure Query Settings In Power BI DAX Studio
- Reid Havens (@HavensBI) presents DAX Anti-Patterns Episode Thirteen - Variables & Comments - with Daniil Maslyuk
- Soheil Bakhshi (@biinsightnz) covers Thin Reports, Real-world Challenges
📊 Report Authoring and Interactivity
- Patrick Leblanc (@GuyInACube) describes Dynamic X and Y Axis in Power BI visuals
- Ruth Pozuelo Martinez (@CurbalEN) describes how to Conditional format the Power BI line chart with a gradient schema
- Greg Deckler (@GregDeckler) describes How To Put Thick Borders On Matrix Visualizations In Power BI
- On the Learning Science YouTube channel, Learning Science talks about Pulse Chart in Power BI - A Custom Visual with Advance and Animated Features
- Daniel Marsh-Patrick (@the_d_mp) announces Deneb 1.3 Generally Available
- Marcus Wegener (@PowerBIler) covers Power BI Karten mit dynamischen Rang [German]
🚀 Deployment, Security and Operations
- On the Power BI blog, Ikechukwu Edeagu (@MSPowerBI) announces Improved Power BI Experience in Excel
- Ted Pattison (@TedPattison) covers Power BI Dev Camp Session 23 - Developing for Power BI using Azure Functions
- On the Purple Frog Systems blog, Jon Fletcher (@PurpleFrogSys) describes how to Upload Power BI Reports using PowerShell
- Olivier Travers (@otravers) writes about Non-Obvious Functional Behavior in Power BI Deployment Pipelines
- David Eldersveld (@dataveld) discusses Trial Power BI Premium Per User for Free with the M365 E5 Sandbox and describes How to Get 25 Free Power BI Premium Per User Licenses for Organizational Pilots
- Bruno M Costa (@BrunoMCosta5) covers Enviar dados de um Power BI dataset por email [Portuguese]
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) discusses Power BI XMLA Endpoints, Demystified
🌐 General
- On the Power BI blog, Maya Shenhav (@MSPowerBI) announces “Data in space” in preview: Now Power BI can be truly everywhere
- Kelly Kaye (@MS_KellyKaye) presents The Power BI Community Show Ep 8 - Power BI, Dynamics 365 & Dataverse
- Reid Havens (@HavensBI) talks about The Future of Power BI (with Mohammad Ali)
- Sam McKay (@_EnterpriseDNA) discusses Power BI Self-service Implementation: What Is Required to Ensure Success With Lars Schreiber