Power BI Weekly
Issue #179 - 18th October 2022
Last week was the Ignite conference, which brought with it a swathe of announcements in the Azure space, but only a handful in the Power BI space. Those announcements are summarized in the Microsoft Ignite 2022: Do more with enterprise self-service business intelligence, with explicit content shared about the
- Cross-tenant Power BI Dataset Sharing (which was actually announced in last month's feature summary)
- Office 365 meet Power BI Desktop (GuyInACube)
Though there are a few more features mentioned in the main blog that it's worth digging into.
One announcement that for some reason didn't make it into that blog is the new Power Query SDK for Visual Studio Code – Public Preview, a great new addition for those creating/maintaining custom connectors. Other announcements have been made apparent to me thanks to a couple of blogs by Matt Allington, who references the New DAX Functions in Excel Data Models and Power Pivot and the fact that there are seemingly No More Auto Aggregations in Dimension Tables - both of which are very welcome improvements!
I mentioned it last week, but I'll mention it again - I'll be running a free, in-person Modern Data DevOps (Data Mesh + Lake House) with Azure Synapse Analytics Workshop in London (UK) on Nov 2nd with my colleague Ian Griffiths. Do sign-up if you'd like to attend!
🛠️ Data Prep
- On the Power BI blog, Miguel Escobar (@EscobarMiguel90) announces Power Query SDK for Visual Studio Code – Public Preview
- Patrick Leblanc (@GuyInACube) explains how to Let Power Query write your SQL for you
- Chandeep Chhabra (@chandeep2786) talks about The Magic of working with Lists in Power Query
- Ruth Pozuelo Martinez (@CurbalEN) describes how to Search for multiple keywords in one column using Power Query
- Rick de Groot (@Rickmaurinus) explains how to Create Last Refresh Time that respects Daylight Saving in Power Query and describes how to Create Date Table with Dynamic Language in Power Query
- Lars Schreiber (@SchreiberLars) covers Arbeitstage für Deutschland, Österreich und Luxemburg Ermitteln Mit Power Query [German]
- On the SQL Shack blog, Gauri Mahajan (@GauriMahajan12) describes Reporting data from Azure Database for PostgreSQL using Power BI
- Chris Webb (@cwebb_bi) writes about What Is The Difference Between A Live Connection And DirectQuery Mode In Power BI?
🧩 Data Modeling
- Chris Webb (@cwebb_bi) describes Finding The Tables, Columns And Measures Used By A DAX Query In Power BI
- Also on the Power BI community blog, Greg Deckler (@GregDeckler) writes about An Alternate Reality: Measure Totals Sum Rows
- On the Power BI community blog, Caiyun Zheng explains How to Calculate Cumulative Values with DAX
- On the Learning Science YouTube channel, Learning Science describes How to use COALESCE DAX function to deal with BLANK values in Power BI
- On the SQLBI blog, Marco Russo (@marcorus) describes Using cross-highlight with order and delivery dates in Power BI
- Sam McKay (@_EnterpriseDNA) covers Getting Started With 'What If' Parameters - Scenario Analysis Techniques [2022 Update]
- Matt Allington (@ExceleratorBI) covers No More Auto Aggregations in Dimension Tables
- Artur König and Mathias Küpper present BI Thinkers Talk XX: Arbeitskalender [German]
- Fowmy Abdulmuttalib (@ExcelFort) covers Power BI Tip: How to Sort a Column with Duplicates by Another Column
- Eiki Sui (@marshal_dabao) shares DAX Studioでサンプルデータを作る [Japanese]
- Matt Allington (@ExceleratorBI) highlights the Major Update to Power Pivot
- ,, Howard Su announces the New DAX Functions in Excel Data Models and Power Pivot
📊 Report Authoring and Interactivity
- Chandeep Chhabra (@chandeep2786) describes Maneuvering Total's Row in Table or Matrix in Power BI
- On the Enterprise DNA blog, Gustaw Dudek (@EnterpriseDNA_) shares Power BI Navigation Tips
- Arnaud Gastelblum (@LazySna1l) explains how to Create a gradient background for Power BI
- Reid Havens (@HavensBI) walks through Upgrading Your Data Labels With Conditional Formatting
- James Andrew (@MatadorSoftware) explains how to Improve Your Power BI Dashboards with Heatmap Tooltips
- Bas Dohmen (@HowToPowerBI) describes Visual Padding, explains how to Create a Pop-Up Panel with Bookmarks in Power BI and shares 5 Design Tricks that Make Every Power BI Report Look Great
- Artur König and Mathias Küpper present BI Thinkers Talk XXI: Feldparameter & Deneb [German]
- Gaelim Holland (@_EnterpriseDNA) describes How To Easily Decompose Time Series Data In Power BI And Python
- Alex Badiu (@BadiuAlexandru) describes the Rule Of Thirds: The Composition Rules
🚀 Deployment, Security and Operations
- On the Power BI blog, Parul Bansal (@MSPowerBI) announces Introducing Cross-tenant Power BI Dataset Sharing
- Adam Saxton (@GuyInACube) covers Office 365 meet Power BI Desktop
- On the Prologika blog, Teo Lachev (@tlachev) blogs about Embedding Power BI Reports in Internal Portals
- Marc Lelijveld (@MarcLelijveld) covers Effect of dataset changes while using deployment pipelines in Power BI
- Sam McKay (@_EnterpriseDNA) describes how to Scale Your Power BI Reporting With Row Level Security [2022 Update]
- Ignacio Barrau (@ignacho_07) covers [SimplePBI][Python] Copiar pbix entre áreas de trabajo [Spanish]
🌐 General
- On the Power BI blog, Kim Manis (@kimmanis) writes about Microsoft Ignite 2022: Do more with enterprise self-service business intelligence
- On the BIFocal podcast, John Patrick White and Jason Himmelstein (@BIFocalShow) present Episode 237 - Power BI announcements from Microsoft Ignite 2022
- Yugo Shimizu (@yugoes1021) covers Microsoft Ignite 2022 - Power BI [Japanese]
- On the Enterprise DNA blog, the Enterprise DNA Team (@_EnterpriseDNA) announce Industries Analytics & Application Summit 2022 – Free Live Virtual Learning Event
- On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) announces Live AMA with Marco Russo & Alberto Ferrari
- The Knee-Deep in Tech team (@KneeDeepinTech) present Podcast episode 208
- On the endjin blog, James Broome (@jamesbroome_) shares Insight Discovery (part 6) – How to define business requirements for a successful cloud data & analytics project
- Yugo Shimizu (@yugoes1021) writes about Microsoft Ignite 2022 - Power BI のアップデート情報 [Japanese]