Power BI Weekly Issue 183: 22nd November 2022
It's a double edition this week with plenty of great content. A few amazing announcements (a couple of which were announced/discussed at the PASS summit), which were the support for paginated reports in Power BI Pro (woop!), the New cache refresh settings available in Power BI Premium, and the new Azure Analysis Services to Power BI Premium automated migration tool. Elsewhere this week, Marco and Alberto has described the new horizontal fusion feature in DAX, Kurt Buhler has summarized the various methods to achieve Measure Selection in Power BI, and Chris Webb has shared a lesser-known method of potentially reducing the size of your model in the blog Why You Should Defragment Your Fact Tables If Youre Using Incremental Refresh In Power BI Premium.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Philipp Lenz (@lenz_philipp) describes how to Change the data source from a local directory to OneDrive inside Power BI
- Ben Gribaudo (@bgribaudo) writes about Power Query PostgreSQL Data Connector Feature Request: Support “Complex” Columns
- Gilbert Quevauvilliers (@GilbertQue) discusses Power Query – Appending text to end of column name
- Chandeep Chhabra (@chandeep2786) explains how to Combine Data from Multiple Excel Files with Inconsistent Column Names in Power Query
- Jon Acampora (@excelcampus) covers The 3 Benefits of Power Query
- James Andrew (@MatadorSoftware) writes about 3 Ways to Simply Compare Matching Values Across Two Files Using Power Query
- Ruth Pozuelo Martinez (@CurbalEN) describes how to Query Mastodon API with Pagination and text token in Power BI
- Reid Havens (@HavensBI) describes Tracking (NULL) Data Input Field Percentage in Power Query!
- On the Enterprise DNA blog, Melissa de Korte (@_EnterpriseDNA) provides an Overview Of The Query Editor User Interface In Power BI, describes Taking On Excel BI's Stacked To Ordered Power Query Challenge and explains How To Perform Conditional Full and Partial Text Replacements In Power Query
- Gaelim Holland (@_EnterpriseDNA) explains How To Use Isolation Forest Machine Learning Algorithm For Outlier Detection Using Python
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) provides an MDX in Power BI tutorial and shares a Tutorial to Create a Power BI Report Using PostgreSQL
- Hima Bindu Marri (@sivahimabindu) explains how to Convert HTML data to Plain text in Power BI
- Miguel Félix writes about Power query – Alguns conceitos base [Portuguese]
- Lars Schreiber (@SchreiberLars) writes Wochendaten auf Tage Verteilen mit Power Query [German]
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Marco Russo & Alberto Ferrari introduce horizontal fusion in DAX, Marco Russo talks about Invalid Relationships – The Whiteboard #09 and Alberto Ferrari talks about SELECTEDMEASUREFORMATSTRING – DAX Guide
- Kurt Buhler (@kurtbuhler) talks about Measure Selection in Power BI and provides a Power BI Analyze-in-Excel Checklist
- Chris Webb (@cwebb_bi) blogs about Performance Tuning Table Visuals With Filters Applied In Power BI
- Patrick Leblanc (@GuyInACube) talks about Writing some DAX while looking at Relationships
- On the Power BI community blog, Xiaoxin Sheng talks about Sorting Multiple Columns
- Marc Lelijveld (@MarcLelijveld) announces Power BI Model Documenter v2.1.0
- On Acuity Training, Ben Richardson (@AcuityTraining) explains How To Create Data Models in Power BI
- Ruth Pozuelo Martinez (@CurbalEN) describes how to Override drillthrough filters in Power BI
- Sam McKay (@_EnterpriseDNA) describes How To Show Percentage Sales Per Custom Group Each Year In Power BI - Advanced DAX [2022 Update], delves into Understanding Anomalies In Power BI With DAX - Analytical Technique [2022 Update] and explains How To Calculate Days Since Last Purchase Using DAX In Power BI [2022 Update]
- On Le CFO Masqué, Kim Leblanc describes how to Grouper des données dans Power BI [French]
- Bernat Agulló (@AgulloBernat) writes about The ultimate snapshot report
- Dhruvin Shah (@DhruvinShah16) explains how to Generate Power BI Measures in Natural Language Quick Measure Suggestions
- Avi Singh (@powerbipro) covers Using the Auto/Date Time Feature in Power BI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Power BI blog, Cookie McCray (@MSPowerBI) announces support for paginated reports in Power BI Pro
- On the Enterprise DNA blog, Sue Bayes (@sue_bayes) blogs about Report Builder In Power BI: Formatting Objects & Visualizations and explains How To Format Data In Report Builder
- On the Power BI community blog, cfriss describes Dynamic Pareto Charts in Power BI - revisualized Part 1 and Part 2
- Reid Havens (@HavensBI) shares the Top Secrets of Power BI Report Design with Mara Pereira
- Mara Pereira (@datapears) covers Text based conditional formatting in Power BI
- On the Towards Data Science blog, Abdullah Kurkcu (@abdullahkurkcu) talks about Creating a Gantt Chart with Power BI
- Bas Dohmen (@HowToPowerBI) describes how to Turn any image into an interactive visual in Power BI
- Leila Gharani (@LeilaGharani) explains How To Use Drill Through in Power BI
- Also on the Enterprise DNA blog, George Mount (@_EnterpriseDNA) talks about R Scripting For Power BI Using RStudio
- On the Learning Science YouTube channel, Learning Science explains how to Personalize visuals in a report - Power BI and explains how to Add a live Power BI report page to PowerPoint
- Bas Dohmen (@HowToPowerBI) writes about Smart Date Axis
- Brian Julius (@_EnterpriseDNA) describes How To Create Dynamic Chart Titles In Power BI
- On LaDataWeb, Guido Maroneo writes Efecto visual sobre las cards para “rellenarlas” o “vaciarlas” [Spanish]
- Alex Badiu (@BadiuAlexandru) writes about Preattentive Attributes: How It Can Impact Your Report
- On the Foresight BI blog, Ahmed Oyelowo (@AhmedOyelowo) covers Understanding Power BI Page Settings (Part 2)
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, Ogbemi Ekwejunor-Etchie writes about New cache refresh settings available in Power BI Premium
- Also on the Power BI blog, Ogbemi Ekwejunor-Etchie explains how to Accelerate your migration experience from Azure Analysis Services to Power BI Premium with the automated migration tool
- Chris Webb (@cwebb_bi) walks through Understanding The Unable to save the changes since the new dataset of size Error In Power BI, describes Why You Should Defragment Your Fact Tables If Youre Using Incremental Refresh In Power BI Premium and walks through Calling The Power BI REST API From TSQL In Azure SQL DB
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes about Incremental refresh in Power BI—everything you need to know
- On the MSSQLTips site, Kenneth A. Omorodion explains how to Configure Incremental Refresh for Non-Query Folding Sources in Power BI Desktop
- Also on the MSSQLTips site, Haroon Ashraf discusses Data Masking and Unmasking Strategy for Power BI Report Testers and Business Users
- Paul Turley (@paul_turley) discusses Developing and Managing Large Power BI Datasets – Part 1
- On the phData blog, Spencer Baucke, Gavin Pedersen, Ahmed Ansari, and Spencer Hamilton describe Implementing Power BI Premium Capacity
- Gilbert Quevauvilliers (@GilbertQue) blogs about Using Power Automate to schedule a refresh of a Power BI dataset at the time you want
- Olivier Travers (@otravers) covers Power Platform Extranets with AAD B2B Users: Using LastPass to Publish with Power BI Desktop Dataflow & XMLA Access And More
- Audrée Pellerin describes how to Partager votre contenu Power BI grâce aux applications [French]
- Marcus Wegener (@PowerBIler) writes Power BI Berichte in Business Central Listen einblenden [German]
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 240 - Interview with Mohammad Ali and Episode 241 - Exciting Paginated Reports News
- The Knee-Deep in Tech team (@KneeDeepinTech) shares Podcast episode 210
- Reid Havens (@HavensBI) explains how to Discover a Learning Framework to Elevate Your PBI Career w/ Steve Campbell
- Adam Saxton (@GuyInACube) presents Power BI tips from the Pros – LIVE w/ Matthew Roche (Nov 12, 2022)
- On the Enterprise DNA blog, Greg Deckler (@GregDeckler) blogs about Planning Power BI Projects
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.