Power BI Weekly Newsletter Issue #191

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

• Maxim Zelensky (@Hohlick) writes about Faster Than Joins! Power Query Record as Dictionary: Part 3
• Ben Gribaudo (@bgribaudo) writes about The Oldest Is Not Always the Minimum: Power Query Date-Based Values May Not Compare the Way You’d Expect
• Chris Webb (@cwebb_bi) discusses Understanding The “A cyclic reference was encountered during evaluation” Error In Power Query In Power BI Or Excel
• On the Power BI community blog, Pär Adeen write about Query Folding - Works better than what you might think
• Chandeep Chhabra (@chandeep2786) talks about Dynamic Query Referencing in Power Query
• Gaelim Holland (@_EnterpriseDNA) describes How To Build A Google News Aggregator In Power BI Using Python
• On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) describes How to Import Data in Power BI Using R
• On the MSSQLTips site, Temidayo Omoniyi (@mssqltips) explains how to Connect Power BI to Azure Data Lake Gen2 Storage for Reporting

Data Modeling

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

• On the SQLBI blog, Marco Russo (@marcorus) covers Debugging DAX measures in Power BI
• On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) describes CROSSJOIN DAX Function: Server Timings & Query Plan
• Bas Dohmen (@HowToPowerBI) discusses WINDOW Function in Action I Examples in Power BI
• Ruth Pozuelo Martinez (@CurbalEN) talks about DAX Fridays #218: Window functions in DAX explained with example
• Greg Deckler (@GregDeckler) writes about Why You Should Take Advantage Of The DAX Table Constructor
• On the Power BI community blog, Nadim Abou-Khalil covers Power BI – Multiple Fact Tables
• Olivier Travers (@otravers) discusses Aggregation Options in Power BI and SQL Server Analysis Services
• Reid Havens (@HavensBI) discusses Power BI Model Documenter - New Updates & Upcoming Features (with Marc Lelijveld)
• On the MSSQLTips site, Koen Verbeeck (@Ko_Ver) explains how to Extend your Power BI Reports with Analysis Services 2022 Data
• On the Power BI community blog, Ted Pattison (@TedPattison) highlights the upcoming Dev Camp session: Building Multi-language Reports for Power BI in 2023

Report Authoring and Interactivity

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

• Sam McKay (@_EnterpriseDNA) explains how to Create Dynamic Visuals Based On Ranking In Power BI With DAX and explains How To Change Size Of Visual Based On Ranking Selection In Power BI Using DAX [2023 Update]
• Reid Havens (@HavensBI) talks about Improving the Data Bar for Tables in Power BI
• On the Learning Science YouTube channel, Learning Science covers the Text Search Slicer Custom Visual in Power BI
• Pat Mahoney (@mahoneypa) explains How to deal with a slow matrix visual in your Power BI report, explains How to troubleshoot a slow matrix/table visual in Power BI and provides A useful "play-taset" for learning and troubleshooting Power BI
• Patrick Leblanc (@GuyInACube) explains how to Allow users to Show and Hide columns in a Power BI Paginated report
• On the Enterprise DNA blog, Sue Bayes (@sue_bayes) covers SSRS Paginated Reports: Line Chart Tutorial
• On the Enterprise DNA blog, Alexandru Badiu (@BadiuAlexandru) walks through Providing Context In Power BI Reports

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, Ikechukwu Edeagu (@MSPowerBI) announces Connected Excel Tables from Power BI (Public Preview)
• Also on the Power BI blog, Kay Unkroth (@MSPowerBI) shares Announcing the Public Preview of Power BI Dataset Scale-Out
• Also on the Power BI blog, Rick Xu announces the My workspace governance improvement (Public Preview)
• Also on the Power BI blog, Wayne Pai announces the backup and restore improvements for large datasets near the size limit
• Also on the Power BI blog, Nikki Waghani (@NikkiWaghani) announces On-premises data gateway December release
• Antriksh Sharma (@AntrikshShar) explains how to Publish Power BI reports using PowerShell Cmdlet
• On the RADACAD blog, Reza Rad (@Rad_Reza) blogs about PowerShell Cmdlets for Power BI: What is it? And Why should you care?, discusses Power BI REST API; What it is and Why it is Important and explains how to Build Your Own Power BI Audit Log; Usage Metrics Across the Entire Tenant
• Gilbert Quevauvilliers (@GilbertQue) explains How to restore large Power BI Premium Backup files

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, Lukasz Pawlowski (@lukasztweets) shares Announcing – Embed your Power BI organizational apps in Microsoft Teams Channels and Meetings
• The Knee-Deep in Tech team (@KneeDeepinTech) present Podcast episode 215

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