Power BI Weekly Issue 185: 6th December 2022
The November Feature Summary has landed, with a number of great additions. It's now possible to have Unshared and unsynchronized axes for small multiples charts (so no more empty looking bar charts!), there's a new Optimize ribbon in Power BI Desktop, allowing you to do things like control when visuals refresh, configure settings, and access the performance analyzer (but unfortunately not auto-optimizing your DAX formulas!), and the new (yet secret) EVALUATEANDLOG and TOCSV/TOJSON functions have now been officially announced. Also, the On-premises data gateway November release has been release, bringing the gateway in line with the latest version of Power BI Desktop.
Elsewhere, we've published a couple of articles corresponding to the videos I shared last week - see our thoughts on Data Storytelling with Power BI: The World Bank World Health and Wealth Report and Accessible Data Storytelling with Power BI: Design Concepts and Accessible Colours.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Chris Webb (@cwebb_bi) describes Web.Contents, Text Concatenation And Dataset Refresh Errors In Power BI/Power Query
- Ben Gribaudo (@bgribaudo) writes about the Extension.LoadFunction, Now With Enhanced Error Reporting!
- Mengting Zhu covers Datamart - Improve user experience
- On the Enterprise DNA blog, Melissa de Korte (@_EnterpriseDNA) provides A Quick Overview On Different Power Query Tools In Power BI
- Bas Dohmen (@HowToPowerBI) describes Better Way to Change the Data Source
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) shares a Masterclass - Microsoft Power Query Fundamentals Concepts with Tips & Tricks, shares a number of tutorials: PQ 9 - Sorting - Power Query - ETL, PQ 10 - Appending Data from Multiple Excel Worksheets, PQ 11 - Appending Data from Multiple Excel Workbooks Same Table Names, PQ 11.1 - Appending Data from Multiple Excel Workbooks Same Sheet Names, PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet Names, PQ 13 - Replace and Fill Down in Power Query, PQ 14 - Formatting Numbers and Dates in Power Query, PQ 15 - Adding Custom Calculated Columns in Power Query, PQ 16 - GroupBy & Merge in Power Query and PQ 17 - Unpivot Columns in Microsoft Power BI
- Also on the Enterprise DNA blog, George Mount (@_EnterpriseDNA) blogs about R For Power BI | A Beginner’s Guide
- Brian Julius (@_EnterpriseDNA) talks about The Most Powerful Function Call In Power BI
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Chris Webb (@cwebb_bi) discusses What's New In Analysis Services 2022?
- Also on the SQLBI blog, Marco Russo (@marcorus) talks about Regular and Limited Relationships – The Whiteboard #10
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) write about Extracting A Query Result In DAX Studio Using The Output Option and describe Data Cache: What It Is And How It Helps To Optimize Queries
- Sam McKay (@_EnterpriseDNA) describes Using The CROSSJOIN Function In Power BI - DAX Concepts [2022 Update]
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes ISSUBTOTAL – DAX Guide
- On the Prologika blog, Teo Lachev (@tlachev) covers Estimating DAX Query Completion Time and discusses Testing DAX Measures
- Kim Leblanc covers Les top mesures en langage DAX [French]
- On the Power BI community blog, Greg Deckler (@GregDeckler) explains how to Configure SQL Server Profiler as an External Tool for Power BI Desktop
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Paul Waller (@Crashbangwaller) covers Accessible Data Storytelling with Power BI: Design Concepts and Accessible Colours
- Barry Smart (@barry_j_a_smart) covers Data Storytelling with Power BI: The World Bank World Health and Wealth Report
- On the Learning Science YouTube channel, Learning Science talks about What is new in Small Multiples Charts in Power BI - November 2022 Update
- On Acuity Training, Ben Richardson (@AcuityTraining) writes about Power BI Report Builder
- On the Power BI community blog, Lucien Wang describes Power BI Report Builder
- Dhruvin Shah (@DhruvinShah16) explains how to Modernize Power BI Paginated Reports
- James Andrew (@MatadorSoftware) covers 2 Powerful Python Visuals You Should be Using in Power BI
- Gaelim Holland (@_EnterpriseDNA) explains How To Create Parallel Coordinate Plots With Python
- Matt Allington (@ExceleratorBI) describes Nesting Measures in Inforiver
- Andrzej Leszkiewicz (@avatorl) covers Florence Nightingale’s Rose Diagram
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, Nikki Waghani (@NikkiWaghani) announces On-premises data gateway November release
- Pat Mahoney (@mahoneypa) talks about Incremental Refresh with SharePoint Files
- Dan English (@denglishbi) describes Azure Analysis Services (AAS) Migration to Power BI Premium Experience
- Gilbert Quevauvilliers (@GilbertQue) walks through Migrating AAS to Power BI Premium – Real World Example (Azure Analysis Services)
- On the Learning Science YouTube channel, Learning Science covers What is row level security?
- On Acuity Training, Ben Richardson (@AcuityTraining) walks through Implementing Row-Level Security In Power BI and describes How to Export From Power BI to Excel
- Sarah Krasnik (@sarahmk125) describes Why and How to Deprecate Dashboards
- Ted Pattison (@TedPattison) presents Power BI Dev Camp Session 27 - Integrating Azure AD B2C with App-Owns-Data Embedding
- Soheil Bakhshi (@biinsightnz) writes about Content Endorsement in Power BI, Part 1, The Basics
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, Jeroen ter Heerdt (@jeroenterheerdt) announces Power BI November 2022 Feature Summary
- On the BIFocal podcast, John Patrick White and Jason Himmelstein (@BIFocalShow) present Episode 242 - Power BI November 2022 Feature Summary
- Miguel Félix covers Atualização Power BI Novembro 2022 [Portuguese]
- Enterprise Dna explains how to Integrated Financial Reporting - Power BI Techniques For Accounting & Finance 2022 Update
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.