Power BI Weekly
Issue #148 - 15th March 2022
It was great to see many of you at SQLBits last week. Thank you to the organizers, volunteers and speakers for such a seamless and high-quality event from start to finish. For those of you that didn't attend and were wondering whether there were any "announcements" - not really (at least not that I know of). There was a focus on goals in one of the sessions and the fact that they're now available for Pro (which you may remember actually happened towards the end of last year). There was talk around the further investment in the Teams + Power BI integration, and that Power BI Desktop will eventually become one of the "core" apps shipped with Office. There were hints around native version control & concurrent editing of PBIX files (but I predict that it will be quite some time before we see either of these things). On the Ops side, we were told about improvements to Data Gateway monitoring, with pre-built apps to help admins govern their gateways. I'll dig through my notes and see if there were any other "upcoming features" that haven't been explicitly mentioned on the official channels, but I think they were the main ones. And remember that you can always check the Power Platform release notes to see what the documented roadmap is.
Back to this week's edition: there was one official announcement, and that's that Dataset backup and restore performance just got a lot better, with huge speed improvements for both types of operations. Elsewhere, Ben Gribaudo has written about Custom Data Connectors and You, describing how you may benefit from creating custom connectors for some of your data sources. Bernat Agulló has come up with a clever way to Showing measure descriptions in tooltips, hooking up to the model's metadata via the XMLA endpoint, and Ruth Pozuelo Martinez has described how to Create elegant lists using DAX and the smart narrative visual in Power BI.
🛠️ Data Prep
- Ben Gribaudo (@bgribaudo) writes about Custom Data Connectors and You
- Gašper Kamenšek (@ExcelUnplugged) writes about Join Types in Power Query – Part 1: Join Types
- Mimoune Djouallah (@mim_djo) shares a First Look at Dynamic M Query parameter using SQL Server
- Patrick Leblanc (@GuyInACube) covers Revisiting a Power BI solution with Dynamic M Parameters
- On the Perficient blog, Vaibhav Punwatkar writes about Dynamic Filtering Using Parameters in Power BI
- Imke Feldmann (@TheBIccountant) shares a Excel YEARFRAC function for Power Query and Excel WEEKNUM function for Power Query
- Marcus Wegener (@PowerBIler) describes how to UTC in lokale Sommer-/Winterzeit umwandeln mit Power Query [German]
🧩 Data Modeling
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) talks about DAX by examples, and shares a few tutorials: RAND, RANDBETWEEN – DAX Guide, BLANK – DAX Guide and VAR.P, VAR.S, VARX.P, VARX.S – DAX Guide
- On the Prologika blog, Teo Lachev (@tlachev) describes Referencing Columns in DAX Table Variables
- On the Enterprise DNA blog, Greg Philps (@_EnterpriseDNA) shares The Ultimate DAX Guide For Beginners
- On the SQL Server Central blog, Adam Aspin describes DAX table functions for paginated reports: Part 2
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) covers Time Intelligence DAX | Current, Previous & SamePeriodLastYear
- Leila Gharani (@LeilaGharani) shares a DAX CALCULATE Trick to Pass Filters from Many to One Side of Relationship
- Hafeez Jimoh (@jimohhafeezco) describes Analyzing Data with Power Pivot and Power BI
- Urish Arora (@urisharora) shares DAX : Script to Create Calendar Table or Date Dimension and describes how to Concatenate Values of a Column in Power BI and DAX
📊 Report Authoring and Interactivity
- Bernat Agulló (@AgulloBernat) describes Showing measure descriptions in tooltips
- Patrick Leblanc (@GuyInACube) covers Tooltips for your Sparkline
- James Andrew explains how to Build Your Own Power BI Progress Bars using Native Visualizations DAX & No DAX Solutions
- Bas Dohmen (@HowToPowerBI) writes about Alternate column or row color in Power BI and talks about GIF Images on Buttons in Power BI Shorts
- Ruth Pozuelo Martinez (@CurbalEN) explains how to Create elegant lists using DAX and the smart narrative visual in Power BI
- Reid Havens (@HavensBI) talks about Creating a Heatmap Chart Combo Using Deneb with Daniel Marsh-Patrick
- Pat Mahoney (@mahoneypa) talks about IBCS-ish Charts with Deneb in Power BI and shares some Deneb Tips For Stacked/Clustered Charts
- On the SQL Shack blog, Gauri Mahajan (@GauriMahajan12) discusses Analyzing data with decomposition trees in Power BI
- On the Learning Science YouTube channel, Learning Science talks about the New Mobile Formatting Options in Power BI - February 2022 Update
- Dhruvin Shah (@DhruvinShah16) talks about the New Format Pane for Power BI Mobile View
🚀 Deployment, Security and Operations
- On the Power BI blog, Wayne Pai writes that Dataset backup and restore performance just got a lot better
- Chris Webb (@cwebb_bi) talks about The ExtAuth Trace Event In Power BI
🌐 General
- On the Power BI community blog, Ted Pattison (@TedPattison) highlights Power BI Dev Camp March 31st, 2022- Scaling Multi-tenant Solutions using Service Principal Profiles