Power BI Weekly Newsletter Issue #224

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

• Chandeep Chhabra (@chandeep2786) describes Power Query Tip | View All Columns at Once and explains how to Remove Nulls & Blanks Together | Power Query Trick
• On the RADACAD blog, Reza Rad (@Rad_Reza) shares Power Query Template: One Giant Leap
• On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) describe Power Query Trim: Explained With Examples
• On the Select Distinct blog, Simon Harrison (@SelectDistLtd) explains how to Connect Power BI to Google Big Query
• On the phData blog, Manish Garg (@phdatainc) blogs about Managing Parameters in Power BI Report Builder with Published Data Sources
• Gilbert Quevauvilliers (@GilbertQue) writes about Part 4 – Creating a Power BI dataset and report using DirectLake
• Rick de Groot (@Rickmaurinus) writes about Power Query M vs SQL: A Balanced Perspective
• Tom Martens (@tommartens68) describes How to connect to a local SQL Server instance that is not that local

Data Modeling

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

• Zoe Douglas (@MSPowerBI) announces calculation groups for Direct Lake datasets
• On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes Negative Value in Round Bracket via DAX - Explicit Measure in Power BI Desktop
• Bas Dohmen (@HowToPowerBI) describes Different People = Different KPIs in Power BI

Report Authoring and Interactivity

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

• On the Power BI blog, Lauren Faber (@MSPowerBI) describes Heads up: Power BI OneDrive and SharePoint report viewing will be on by default starting in October
• Kurt Buhler (@kurtbuhler) covers KPIs and cards in Power BI
• Bas Dohmen (@HowToPowerBI) covers Mastering Bar Charts in Power BI | No More Cut Labels and describes a Histogram with Dynamic Bins in Power BI
• On the MSSQLTips site, Harris Amjad (@mssqltips) explains how to Build Clustered Column Chart and Clustered Bar Chart in Power BI Desktop
• Chandeep Chhabra (@chandeep2786) shares a Resizing Columns Trick in Power BI and describes How to Make a Calendar Dashboard in Power BI
• Kim Leblanc covers Explorez l’interaction sur objet dans Power BI avec ces 3 phases clés [French]
• On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) describes How to Embed Power BI in SharePoint: 4 Simple Steps
• Leila Gharani (@LeilaGharani) shares the Easiest Ways to Export Power BI to Excel Smoothly and Efficiently (new updates included)
• Bala Madhusoodhanan (@balagmadhu) presents a Running Bar Chat

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, Rui Romano (@RuiRomano) announces Dataset Refresh History Enhancements
• Tom Martens (@tommartens68) writes about Power BI licensing, an eternal mystery, and now - there is also Fabric licensing
• On the Power BI blog, Maya Shenhav (@MSPowerBI) writes about Supporting Azure Active Directory shared device mode (preview) for Power BI Mobile apps

General

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

• Ryan Majidimehr (@MSPowerBI) announces Microsoft Fabric August 2023 update
• Kevin Miller (@MSPowerBI) presents Microsoft’s Justice Reform Initiative uses data driven insights to empower communities
• Chris Webb (@cwebb_bi) shares Some Thoughts On Third-Party Tools For Power BI
• Reid Havens (@HavensBI) talks about Starter Extensions for Visual Studio Code and Power BI (with Štěpán Rešl)

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