Power BI Weekly Issue 200: 28th March 2023
Welcome to the 200th edition of Power BI Weekly! Another milestone for the Power BI Weekly newsletter - thanks as ever to all of you for subscribing/reading. There's a few official blogs this week: firstly, there's been the On-premises data gateway March release (reiterating the fact that gateways running versions older than April 2021 might now fail), we've been told about Hierarchies performance tips in Power BI Metrics, and there's been a blog describing how we can Explore new capabilities in Microsoft Power BI at the Microsoft Business Applications Launch Event on Tuesday, April 4, 202 (for which we can register for free). Otherwise this week, my colleague Barry has written a blog summarizing SQLbits 2023 - The Best Bits, and, by popular demand it seems, the SQLBits team has actually already shared the recording about The Future of Version Control for Tabular Models with Mathias Thierbach and Gabi Münster, talking all about the new TMDL language (pronounced "Timdull", if you were wondering) which I spoke about last week. Definitely worth a watch!
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Rick de Groot (@Rickmaurinus) covers Creating a Monthly Date Table in Power Query M
- Chris Webb (@cwebb_bi) writes about Why Doesn't Power Query Know If My Step Will Fold?
- Adam Saxton (@GuyInACube) describes how to Visually see where you broke the fold in Power Query
- On myOnlineTraininghub, Mynda Treacy (@OnlineTrainingH) talks about Power Query if Statements incl. Nested ifs, if or, if and
- Chandeep Chhabra (@chandeep2786) describes 5 Best Practices in Power Query
- On the Learning Science YouTube channel, Learning Science explains how to Convert html text to plain text in Power Query for Power BI
- Belinda Allen (@MsBelindaAllen) talks about Parameters for Excel File Path in Microsoft Power BI
- Gaelim Holland (@_EnterpriseDNA) describes How To Convert Continuous Data Into Categorical In Power BI Using Python
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Erik Svensen (@donsvensen) covers Document your Power BI model with chatGPT and a Tabular Editor script and browse it in your model
- On the SQLBI blog, Marco Russo (@marcorus) describes DAX Studio Server FE Benchmark – Unplugged #51
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) covers Understanding different cache types in Power BI
- Sam McKay (@_EnterpriseDNA) explains How To Know What Are Causing The Changes In Your Data Using DAX [2023 Update]
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Laura Graham-Brown (@Laura_GB) describes Power BI – Clear all Slicers Button
- Reid Havens (@HavensBI) discusses IBCS Styled Bullet Chart for Native Tables in Power BI
- On the Enterprise DNA blog, the Enterprise DNA Team (@_EnterpriseDNA) describes How to Use KPI in Power BI – Let us Explain
- Bas Dohmen (@HowToPowerBI) describes how to Supercharge Visuals in Power BI | Add KPIs to Titles
- Also on the Enterprise DNA blog, Sue Bayes (@sue_bayes) blogs about Report Builder In Power BI: Formatting Objects & Visualizations
- Brian Julius (@_EnterpriseDNA) describes How To Identify And Optimize Slow Power BI Visuals and explains How To Test And Develop Color-blind Friendly Themes For Your Power BI Report
- On the Power BI community blog, Milan Mejzr discusses Light & Dark theme together in Power BI
- Belinda Allen (@MsBelindaAllen) blogs about Microsoft Power BI Story Telling with PowerPoint
- Davide Bacci shared a Deneb Gantt chart visual
- Ignacio Barrau (@ignacho_07) writes [StoryTelling] This is Roger Federer [Spanish]
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) shares the On-premises data gateway March release
- On the Power BI blog, Carly Newsome (@MSPowerBI) shares Power BI Metrics: Hierarchies performance tips
- Chris Webb (@cwebb_bi) covers Power BI TMDL And Version Control Announcements From SQLBits
- Marc Lelijveld (@MarcLelijveld) describes how to Successfully collaborate with Externals in Power BI
- Patrick Leblanc (@GuyInACube) delves into Checking out the new Power BI RLS Editor
- Gilbert Quevauvilliers (@GilbertQue) covers Refreshing a Power BI Dataset using an HTTPS URL
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes Getting Started with Microsoft Power BI Service (Cloud Account) Fundamentals
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, Kim Manis (@kimmanis) announces Explore new capabilities in Microsoft Power BI at the Microsoft Business Applications Launch Event
- Patrick Baumgartner (@patbaum) talks about Gartner Analytics and BI Bake-off 2023: Analysis of Flooding and Flood Mitigation
- Adam Saxton (@GuyInACube) presents Power BI Adoption and More Q&A with Melissa Coates and Matthew Roche
- On the Enterprise DNA blog, the Enterprise DNA Team (@_EnterpriseDNA) describe What is Power BI? The Ultimate Guide to Microsoft’s BI Tool
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.