Power BI Weekly Issue 131: 26th October 2021
Welcome to the 131st edition of Power BI Weekly! Again, a pretty quiet week from Microsoft's side, with the main highlight being the GA of Azure Purview and its integration with Power BI, helping your organisation's data governance needs. Otherwise the only announcement to come from Power BI is that the On-premises data gateway October 2021 update is now available, which must be the brieffest update summary there's ever been!
A few articles to highlight this week - Bernat Agulló has described Building arbitrary tables with 2-level column headers with yet another clever use of calc groups, Mara Pereira has spoken about Power BI query reduction - Add an Apply all filters button to your report, building on top of the default "Apply all" behaviour to save on real-estate on the report canvas, and Marco Russo has spoken about the potential benefits of a lesser-used feature of Power BI in the blog: Implementing real-time updates in Power BI using push datasets instead of DirectQuery.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Chris Webb (@cwebb_bi) covers Refreshing Power Pivot Excel Data Models That Use The Current Workbook As A Data Source In Excel Online
- On the Enterprise DNA blog, Melissa de Korte (@_EnterpriseDNA) shares a Power Query Editor Tutorial: Extract Record Field Values From Lists and and a Power Query M Language Tutorial And Mastery
- Erik Svensen (@donsvensen) writes about PowerQuery – Add Year, Month and Day to your date table with Date.ToRecord
- Chandeep Chhabra (@chandeep2786) shares 5 Tricks to Reduce Steps in Power Query
- Ruth Pozuelo Martinez (@CurbalEN) describes how to Fix M intellisense once and for all
- Bryant Avey (@BryantAvey) presents Pattern-Driven Insight: Integrating Neo4j with Power BI
- Hima Bindu Marri (@sivahimabindu) describes Why and how to connect to a website through Power BI desktop
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Marco Russo (@marcorus) describes Implementing real-time updates in Power BI using push datasets instead of DirectQuery
- Also on the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes Creating real time dashboards in Power BI with push datasets, blogs about Controlling drillthrough in Excel PivotTables connected to Power BI or Analysis Services, and shares the tutorials Binary – DAX Guide and IF – DAX Guide
- On LaDataWeb, Ignacio Barrau (@ignacho_07) writes Modelar hechos con distintas granularidades de fecha [Spanish]
- On the MSSQLTips site, Kenneth A. Omorodion explains how to Combine Text Strings in Power BI Using DAX
- Dhruvin Shah (@DhruvinShah16) presents Power BI DAX for Beginners: MIN, MAX, MINX, MAXX, MINA, MINX
- On the Power BI Tips and Tricks blog, James Bartlett shares Business Ops: New and Updated External Tools
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Bernat Agulló (@AgulloBernat) describes Building arbitrary tables with 2-level column headers
- Business Intelligist (@bizintelligist) describes How to Display Multiple Rows in a Single Cell of a Matrix or a Table
- Mara Pereira (@datapears) discusses Power BI query reduction - Add an Apply all filters button to your report
- On the Power BI community blog, Fowmy Abdulmuttalib (@ExcelFort) describes how to Highlight lowest and highest periods dynamically on Power BI Chart
- Also on the Power BI community blog, Icey Zhang explains How to return forecasted values as a table in a R visual
- Bas Dohmen (@HowToPowerBI) provides Multiple KPIs with line breaks on hover in Power BI
- Ruth Pozuelo Martinez (@CurbalEN) describes How to keep your charts on PowerPoint and MS Word reports automatically updated!! | Power BI, Excel
- On the MSSQLTips site, Scott Murray writes about Power BI Report Automation
- Felix Gemander shares a Quick Tipp - Power BI - Diagramm erstellen und formatieren | Dashboard Heroes [German]
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On the Power BI blog, Miquella de Boer shares that the On-premises data gateway October 2021 update is now available
- On the Power GI blog, Cyrus Christian writes about the Power BI Premium Gen 2 Metrics App for GCC
- Gilbert Quevauvilliers (@GilbertQue) describes How to resolve error when deploying changes to Power BI Premium Per User for Incremental partitions
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the Power BI blog, Yarden Albeck writes that Microsoft Power BI and Azure Purview better together – now Generally Available
- Adam Saxton (@GuyInACube) highlights the Power BI tips from the Pros – LIVE w/ Paul Turley (October 23, 2021)
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 208 - Power BI October 2021 Feature Summary
- Reid Havens (@HavensBI) blogs about The Skills Your Power BI Team Needs to Succeed with Ed Hansberry
- Matt Allington (@ExceleratorBI) writes about 5 New Features I Love – Coming Soon to Power BI
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.