Power BI Weekly Issue 180: 24th October 2022
Welcome to the 180th edition of Power BI Weekly! We've been given the Power BI October 2022 Feature Summary this week, and there are a few gems in there. There's a new experimental feature around Quick measure suggestions, whereby you can type your calculation in plain language and have Power BI take a crack at writing your DAX code for you. Pretty neat - though I wonder what the accuracy will be like! In the model view in Power BI Desktop we now have Relationship editing in the properties pane, and DAX formula bar support for Desktop model view (so no more switching tabs just to see your measure/column/table logic). It is also now possible to Download a PBIX from the Power BI Service for more scenarios, and we have been told about the new submetric roll ups in Power BI Metrics.
Finally, this is the last call for those who want to attend our free, in-person Modern Data DevOps with Azure Synapse Analytics Workshop in London (UK) on Nov 2nd (next Wednesday). Sign-up within the next day if you'd like to attend!
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Chandeep Chhabra (@chandeep2786) talks about Each & Underscore_ in Power Query
- Rick de Groot (@Rickmaurinus) discusses The IN Operator in Power Query
- Melissa de Korte (@_EnterpriseDNA) explains How To Filter By A Specific First Letter Or Character In Power Query and describes How To Add A Conditional Index In Power Query
- James Andrew (@MatadorSoftware) explains how to Improve Power Query Efficiency by Replicating the SQL IN Operator
- Sam McKay (@_EnterpriseDNA) shares Best Practice Tips For Using The Advanced Editor In Power BI [2022 Update]
- Gilbert Quevauvilliers (@GilbertQue) blogs about Getting the lineage from a Power BI dataset to table to data source to original query
- On the Power BI community blog, Shaurya describes How to Export Telemetry Data from Azure IoT Central into Power BI
- Lars Schreiber (@SchreiberLars) covers Artikelnummern und Einkäufer zusammenführen mit Power Query [German]
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Marco Russo (@marcorus) describes One-to-Many Relationships – The Whiteboard #08
- Hima Bindu Marri (@sivahimabindu) talks about Custom Format Date in Power BI
- Bas Dohmen (@HowToPowerBI) describes New in Power BI Quick Measure Suggestions
- On the endjin blog, Jessica Hill (@JessRoseHill_) covers EVALUATEANDLOG in DAX
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes ISSELECTEDMEASURE – DAX Guide
- Sam McKay (@_EnterpriseDNA) describes How To Compare Performance Using The ALL Function In Power BI [2022 Update]
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) write about Power BI Compression Techniques In DAX Studio
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) explains how to Optimize Power BI data model with Tabular Editor
- On the Prologika blog, Teo Lachev (@tlachev) writes about Resolving Tabular Conversion Errors and describes Correlating Analysis Services Errors with Measures
- Also on the Towards Data Science blog, Salvatore Cagliari (@TDataScience) explains How to use Small multiples in Power BI to show multiple Measures
- Prathy Kamasani (@pkamasani) covers Switch Between a Summarized Value or Selected Value with Multiple Legends
- Mimoune Djouallah (@mim_djo) writes about Power BI Query plan when using Top N filter
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Power BI blog, Carly Newsome covers Announcing submetric roll ups in Power BI Metrics
- Reid Havens (@HavensBI) describes Two Ways to Create Single Value Input Slicers in Power BI
- Bas Dohmen (@HowToPowerBI) describes how to Clear All Slicers with 1 Click and describes how to Format Multiple Visuals at Once
- Ruth Pozuelo Martinez (@CurbalEN) explains how to Create and test color palettes for your data project quickly and easily
- Andrzej Leszkiewicz (@avatorl) blogs about Power BI: advanced Radar Charts using Deneb-Vega
- Gaelim Holland (@_EnterpriseDNA) explains How To Use ECDF Plots With Python And Power BI
- On the Learning Science YouTube channel, Learning Science explains How to export Power BI report to PDF file from Power BI Desktop
- Sue Bayes (@sue_bayes) covers Create A Paginated Report: Adding Texts & Images
- Adam Saxton (@GuyInACube) provides A better way to share Personal Bookmarks in Power BI
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On Acuity Training, Ben Richardson (@AcuityTraining) writes about Dynamic Row Level Security in Power BI
- On the MSSQLTips site, Bhavesh Patel explains how to Refresh a Power BI Dataset using Microsoft Power Automate
- Reid Havens (@HavensBI) walks through Configuring Incremental Refresh PBI-Tools (with Mathias Thierbach) and talks about PowerShell Hacks for Power BI (with James Bartlett)
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 October 2022 Feature Summary
- On the BIFocal podcast, John Patrick White and Jason Himmelstein (@BIFocalShow) present Episode 238 - Power BI October 2022 Feature Summary
- Michael Felix covers Atualização Power BI Outubro 2022 [Portuguese]
- Paul Turley (@paul_turley) blogs about Power BI Object Names – Why Standards Are Important
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.