Power BI Weekly Newsletter Issue #205

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

• On the MSSQLTips site, Aseel Al-Laham describes how to Change Power BI Reports Source from Multidimensional SSAS Cube to Tabular
• Chandeep Chhabra (@chandeep2786) describes how to Unstack Uneven Rows to Columns in Power Query
• Brian Julius (@_EnterpriseDNA) talks about Three Ways To Avoid The Common Split By Delimiters Trap
• Antriksh Sharma (@AntrikshShar) explains how to Convert Hour Minute Seconds text to Minutes in Power Query
• On the Kohera blog, Kohera (@Kohera_be) explains How to easily parse JSON in Power BI Desktop
• Laura Graham-Brown (@Laura_GB) writes about Using SQL on Dataverse for Power BI
• Gaelim Holland (@_EnterpriseDNA) talks about Finding Similar Matches With Euclidean Distance Using Python In Power BI

Data Modeling

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

• On the SQLBI blog, Marco Russo (@marcorus) discusses Rounding errors with different data types in DAX
• On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) explains how to Analyze performance when aggregating data in Power BI and DAX Queries
• Kurt Buhler (@kurtbuhler) describes How to unlock new features in Power BI datasets managed with Tabular Editor
• Antriksh Sharma (@AntrikshShar) writes about ALL Functions vs Security in DAX and describes Installing TOM Library to connect Python to Power BI &38 SSAS
• On the SQL Server Central blog, Kenneth A. Omorodion (@mssqltips) describes How to Slice Data by Week in a Calendar Table using DAX
• Sue Bayes (@sue_bayes) writes about DAX Debugging in Tabular Editor 3
• Sam McKay (@_EnterpriseDNA) describes how to Find Weekday & Weekend Day Numbers Within Months - Advanced DAX [2023 Update]
• Koen Verbeeck (@Ko_Ver) covers Star Schema vs Snowflake Schema Considerations
• On the Select Distinct blog, Select Distinct (@SelectDistLtd) describes Rolling Averages and Rolling Sums in Power BI
• Gilbert Quevauvilliers (@GilbertQue) explains How to modify Dynamic Format Strings in Power BI
• Brian Julius (@_EnterpriseDNA) explains How To Use The Dynamic Format Strings Feature - Power BI April 2023 Updates

Report Authoring and Interactivity

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

• On the Power BI blog, Noam Raveh (@MSPowerBI) explains how to Create Power BI reports in Jupyter Notebooks
• Bernat Agulló Roselló (@AgulloBernat) covers A nice background always, with the minimum effort
• On the Learning Science YouTube channel, Learning Science explains how to Apply all slicers and Clear all slicers buttons in Power BI
• Davide Bacci shares the Deneb Showcase containing all the creations over the past few months
• On the Power BI community blog, Abbas Godhrawala shares Learn How to Display Text Labels Inside Bars for Clear and Space-Efficient Data Visualization
• David Eldersveld (@dataveld) explains how to Heighten Data Literacy with the Power BI Natural Language Q&A Visual
• On the MSSQLTips site, Kenneth A. Omorodion (@mssqltips) describes how to Change the Default Output on a Power BI KPI Visual
• Reid Havens (@HavensBI) covers Power BI Visual Revolution - AMA (Ask me anything) with Miguel Myers
• On the Towards Data Science blog, Thomas A Dorfer (@ThomasADorfer) describes Quick and Easy Time-Series Forecasting in Power BI: A Practical Guide
• Vahid Doustimajd (@VahidDoustiM) covers PAC-MAN Meets Power BI: How to Add Retro Fun to your reports
• Sue Bayes (@sue_bayes) explains how to Create a linked Excel table from your Power BI report

Deployment, Security and Operations

Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling

• Reid Havens (@HavensBI) walks through Governing Sensitive Data Using Microsoft Purview (with Anton Fritz)
• Ted Pattison (@TedPattison) delves into Power BI Dev Camp Session 32 - Design Guidelines and Best Practices with Power BI Embedding
• On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) talks about Dynamic Row Level Security in Power BI
• Chris Webb (@cwebb_bi) discusses Measuring Memory And CPU Usage In Power BI During Dataset Refresh and covers Understanding WaitTime In Power BI
• Soheil Bakhshi (@biinsightnz) covers Power BI Governance, What Organisations Need to Know

General

Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs

• On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 254 - Interview with Emily Lisa
• On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) describe How to Use Chat GPT for Power BI
• Ryan Palmer and Allen Kim (@MSPowerBI) talk about Microsoft's Airband Initiative uses Power BI to advance Digital Equity

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
• 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