Power BI Weekly Newsletter Issue #200

powered by endjin

If you have any content you'd like to contribute to the newsletter, please tweet @PowerBIWeekly or ping an email to PowerBIWeekly@endjin.com.

Interested in Azure? Sign up to our sibling newsletter Azure Weekly to receive all the week's Azure news.

@edfreeman_ | @endjin
powerbiweekly.info | endjin.com

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

Useful Links

• Azure Weekly - Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news
• M language reference - Official Power Query M Reference
• DAX Studio - Useful open source tool for executing and analyzing DAX queries, founded by Darren Gosbell
• DAX Guide - Your go-to reference on the DAX language, created by the SQLBI team
• Power BI Visuals Reference - An exhaustive list (as of Sep. 2018) of all Power BI native & custom visuals, placed into separate categories, again created by the SQLBI team
• Report Theme Generator - A handy report theme generator created by the Power BI Tips and Tricks team
• Power BI Theme templates - Detailed Power BI Theme templates for all the native visuals, created by David Eldersveld
• Power BI from Rookie to Rock Star - Free, detailed eBook to get up and running with Power BI, written by Reza Rad
• Power BI Architecture diagram - An informative Power BI Architecture diagram, created by Dustin Ryan
• Power BI Whitepapers - A list of official Power BI whitepapers, covering Security, Premium deployment, Advanced Analytics and more