Power BI Weekly
Issue #193 - 7th February 2023
Just the one update this week, which is the Power BI Datamart – January 2023 Feature Summary. This includes updates to the datamart editor, the ability to take over ownership, and a new SQL connection string that can connect to any 3rd party client tool; alongside some updates highlighting which features are under review or already being worked on. Aside from that this week, we've had a number of great blogs focussing on data viz: Paul Waller has described How to develop an accessible colour palette for Power BI, Davide Bacci has shown the art of the possible with Deneb by creating a Covid time-lapse visual, and Darren Gosbell has shown various ways to Hack a bar chart into table.
🛠️ Data Prep
- Chris Webb (@cwebb_bi) blogs about The “Block length does not match with its complement” Error In Power Query In Power BI And Excel
- Soheil Bakhshi (@biinsightnz) discusses Datatype Conversion in Power Query Affects Data Modeling in Power BI
- On the Power BI community blog, Ignacio Barrau (@ignacho_07) discusses PowerQuery Tips to reduce steps in query editor
- Paul Turley (@paul_turley) talks about Power BI and the Dimensional Dilemma
- Allison Kennedy (@ExcelAllison) talks about Working with Dates Regional Formats
- Chandeep Chhabra (@chandeep2786) talks about Removing & Keeping Duplicates in Lookup Tables
- Olivier Travers (@otravers) describes SQL Performance Tuning for Power BI Devs Who Don’t Know Database Architecture and blogs about Connecting to Power BI Datamart and PowerApps Dataverses SQL Server from Desktop Tools and External Services
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes how to Unstack Uneven Data Across Columns or Pivot Data & Append Row wise Power Query Microsoft Excel
- Lars Schreiber (@SchreiberLars) shares Ranglisten mit Power Query Erstellen [German]
🧩 Data Modeling
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) introduces window functions in DAX
- Antriksh Sharma (@AntrikshShar) describes how to Extract model.bim file from Power BI & SSAS Tabular with Python
- Sam McKay (@_EnterpriseDNA) describes How To Calculate Running Totals In Power BI Using DAX 2023 Update and explains how to Calculate The Difference In Days Between Purchases Or Events In Power BI Using DAX
- Brian Julius (@_EnterpriseDNA) describes How To Bulk Copy Measures From Different Reports In Power BI
- On the Power BI community blog, Nadim Abou-Khalil discusses Power BI – Dynamic Benchmarking
- On the Learning Science YouTube channel, Learning Science describes How ChatGPT helps to write DAX measures in Power BI
📊 Report Authoring and Interactivity
- On the endjin blog, Paul Waller (@Crashbangwaller) explains How to develop an accessible colour palette for Power BI
- Darren Gosbell (@darrengosbell) covers Power BI: Hacking a bar chart into table
- On the Enterprise DNA blog, Alexandru Badiu (@BadiuAlexandru) writes about 9 Tips To Improve Clarity In Power BI Reporting and shares the Best Power BI Dashboard Design Tips
- Reid Havens (@HavensBI) talks about Quick & Easy Icons in Titles/Labels for Power BI
- Pat Mahoney (@mahoneypa) delves into Options for Dynamic Text with the Deneb Power BI Visual and blogs about Leveraging Field Parameters with the Deneb Power BI Visual
- Davide Bacci shares a Deneb Covid time-lapse visual and Deneb Animated Beeswarm chart visual
🚀 Deployment, Security and Operations
- On the RADACAD blog, Reza Rad (@Rad_Reza) discusses Power BI Workspace Collaborative DEV Environment
- Marc Lelijveld (@MarcLelijveld) writes about Multiple audiences for Power BI apps, will it change your workspace setup?
- On the PowerPivotPro blog, Kristi Cantor (@cajuncody) blogs about Power BI Usage Metric Reporting: A Guide to Game-Changing Insights
- Gilbert Quevauvilliers (@GilbertQue) walks through Automating the backup of Power BI Premium datasets/databases – Part 1
- Vahid Doustimajd (@VahidDoustiM) explains how to Restart Power BI Hybrid Dataset with Power Automate and APIs
- Dhruvin Shah (@DhruvinShah16) talks about Power BI Admins Gain My Workspace Access
- Dan English (@denglishbi) describes Power BI Report Source Redirection after AAS to PBI Migration
- Kim Leblanc writes Pipeline de déploiement : facilitez la maintenance dans Power BI [French]
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) talks about Deployment Strategies In Power BI: An Overview
🌐 General
- On the Power BI blog, Salil Kanade shares Power BI Datamart – January 2023 Feature Summary
- The Knee-Deep in Tech team (@KneeDeepinTech) shares Podcast episode 216
- Sam McKay (@_EnterpriseDNA) discusses Building an Inclusive Data Culture with Chris Wagner
- Reid Havens (@HavensBI) discusses Making The Most Out of The Power Platform with Nicky van Vroenhoven
- Adam Saxton and Patrick Leblanc (@GuyInACube) presents Power BI tips from the Pros – LIVE (Feb 4, 2023)