Power BI Weekly Newsletter Issue #242

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

• Jon Acampora (@excelcampus) writes about Excel Clean Up with Power Query: Say Goodbye to Messy Data Forever
• On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) talks about Web Scraping | "Add Column from Examples" Power Query in Excel
• Oz du Soleil (@OzExcel) discusses Power Query: Referencing Vs Duplicating Queries

Data Modeling

Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models

• On the Tabular Editor blog, Kurt Buhler (@kurtbuhler) explains how to Prepare your data for a semantic model
• On the SQLBI blog, Marco Russo (@marcorus) delves into Using tuple syntax in DAX expressions
• Bernat Agulló Roselló (@AgulloBernat) writes about I want it all in one page
• On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) writes About Calculating Sales depending on another Value in DAX
• Chandeep Chhabra (@chandeep2786) explains how to Compare Two Tables Using DAX in Power BI
• On the Learning Science YouTube channel, Learning Science explains How to calculate 3 weeks rolling total in Power BI Calculate 3 weeks running sum in Power BI

Report Authoring and Interactivity

Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards

• Reid Havens (@HavensBI) introduces PowerOps Desktop (Free) for Power BI (with Vijay Hemantha)
• Chandeep Chhabra (@chandeep2786) describes How to Fill the Area Between Lines in a Line Chart in Power BI
• Andrzej Leszkiewicz (@avatorl) answers What is more important? Data (ETL, data modeling) or data visualization?, describes how to Use interactivity and animation to guide report users and shares a Power BI data modeling/data visualization tip: When you need a ‘chimera’, create it!
• Madison Giammaria shares an updated Radial / Line Combo Chart in Deneb
• The Datachant Team discusses Power BI Custom Visuals Downloads
• On the MSSQLTips site, Harris Amjad (@mssqltips) explains how to Build Stacked Column and Bar Chart in Power BI

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, Michael Bruhjell (@MSPowerBI) writes about Dynamic subscriptions for Power BI reports (Preview)
• Chris Webb (@cwebb_bi) talks about Extracting Power BI Import Mode Job Graph Data To A Table and highlights the New Limits For The “Maximum Connections Per Data Source” Property In Power BI DirectQuery Mode
• Max Wikström (@maxwiks) shares some Top tips to speed up your Power BI DirectQuery semantic models
• Greg Low (@greglow) blogs about Power BI Implementation Models for Enterprises Part 2: Cloud Native Clients
• Wolfgang Strasser (@wstrasser) resolves the error Copilot for Microsoft Fabric not available because its capacity is located outside your tenant’s region

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) writes about the New Fabric certification and Fabric Career Hub
• Also on the Power BI blog, Mohammad Ali (@mohaali45) highlights that Copilot in Power BI (preview) is available worldwide
• Arun Ulagaratchagan (@arunulag) tells you to Save your seat at the ultimate Fabric learning event!
• On the Power BI Tips and Tricks blog, the Explicit Measures podcast team (@PowerBITips) talks about Creative Thinking in Fabric & Power BI
• Adam Saxton (@GuyInACube) shares a Power BI Tutorial for Beginners (2024) and Adam Saxton and Patrick Leblanc present REPLAY Microsoft Fabric / Power BI Q&A - LIVE (Jan 20, 2023)

Useful Links

• Power BI Maturity Scorecard - 97% of the Fortune 500 are using Power BI. Only 20% of analytics deliver business value. How do you score?
• 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
• PowerQuery How - Alternative M Language Reference created by Rick de Groot, including improved function explanations, code formatting, practical examples and further reading
• 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