Power BI Weekly Newsletter Issue #172

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

• Jonathan Law covers A deep dive into Power BI incremental refresh feature
• Marcus Wegener (@PowerBIler) shares the recording from the Power BI – UK User Group: Exploring the Power BI Datamarts
• On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) hosts Incremental Refresh and Hybrid Tables in Power BI by Shabnam Watson (Auckland Power BI User Group)
• Ruth Pozuelo Martinez (@CurbalEN) describes a New way of Dealing with errors in Power Query
• On the RADACAD blog, Leila Etaati (@leila_etaati) writes about Azure Machine Learning Call API from Power Query
• James Andrew (@MatadorSoftware) describes how to Simply Create a Summary Table in Power Query
• Lars Schreiber (@SchreiberLars) covers Tabellenüberschriften massenhaft und dynamisch umbenennen mit Power Query [German]
• Soheil Bakhshi (@biinsightnz) writes about Slowly Changing Dimension (SCD) in Power BI, Part 2, Implementing SCD 1

Data Modeling

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

• Darren Gosbell (@darrengosbell) announces DAX Studio v3 released
• On the SQLBI blog, Marco Russo (@marcorus) announces DAX Studio 3 released
• Also on the SQLBI blog, Marco Russo (@marcorus) talks about Expanded Table – The Whiteboard #04 and talks about VertiPaq Analyzer crash course
• Adam Saxton and Patrick Leblanc (@GuyInACube) talk about DAX Studio 3 is out! LIVE w/ Marco Russo (Aug 27, 2022)
• Jeffrey Wang (@jwang_pbi) explains how to Understand the Output of EvaluateAndLog Function of Scalar Expressions and explains how to Understand The Output of EvaluateAndLog Function of Table Expressions
• Chris Webb (@cwebb_bi) writes about Why I’m Excited About The New DAX EvaluateAndLog() Function
• On the Enterprise DNA blog, Antriksh Sharma (@AntrikshShar) delves into DAX Query In Power BI: Understanding Its Logical Flow and blogs about Format DAX Codes Using DAX Studio's Special Features
• Matt Allington (@ExceleratorBI) talks about Introduction to Power BI and DAX
• On the Power BI community blog, Eason Fang describes how to Calculate the working days between two dates excluding weekends and holidays
• On the Tessellation Tech blog, Nabila Mohamed describes How to Create a Bridge Table in Power BI
• On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes DEFINE COLUMN – DAX Guide and describes DAX 101: Using RELATED and RELATEDTABLE in DAX
• Max Wikström (@maxwiks) writes about Inside Power BI – Compression and the power of Vertipaq and covers Level up your Power BI model using DAX Studio – Part 1
• Bernat Agulló Roselló (@AgulloBernat) describes Building a fading bar chart
• Chandeep Chhabra (@chandeep2786) describes Custom Data Labels in Power BI
• Arnaud Gastelblum (@LazySna1l) covers Power BI Sidetools extensions: A Must Have
• On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) discusses Power BI and Excel Integration

Report Authoring and Interactivity

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

• Patrick Leblanc (@GuyInACube) discusses Slicers vs. Slicer Pane vs. Filter Pane! Which is faster? and explains how to Simulate Hierarchies with Field Parameters in Power BI
• Brian Julius (@_EnterpriseDNA) describes How To Quickly Add Dynamic SVG Visuals To Your Power BI Report
• On the Enterprise DNA blog, Sue Bayes (@sue_bayes) describes Paginated Report In Power BI: An Introduction
• Bas Dohmen (@HowToPowerBI) describes The Ultimate Slicer Panel in Power BI
• Lars Schreiber (@SchreiberLars) describes Wie Du in Power BI Leerwerte in Datenschnitten verhinderst [German]
• Reid Havens (@HavensBI) describes Customized Bar Chart Using a Matrix Visual + Conditional Formatting (with Gustaw Dudek)
• On the Learning Science YouTube channel, Learning Science describes Bookmarks for Selected Visual in Power BI
• On the Bridge All blog, Ryan Chatham writes about New Power BI metric & scorecard features
• Andrzej Leszkiewicz (@avatorl) discusses Map with Pie Charts?
• Sam McKay (@_EnterpriseDNA) covers Field Parameters Combined With Small Multiples In Power BI - An Amazing Combination and highlights Get Inspired By These Excellent Power BI Examples - Innovative Techniques And Cool Features
• Philipp Lenz (@lenz_philipp) covers Power BI and Visio
• Daniel Marsh-Patrick (@the_d_mp) provides A Study on Hills and Valleys in Power BI with Deneb
• On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) describes Tips to improve Power BI report appeal

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, Yael Biss (@MSPowerBI) announces Updates to Microsoft Purview data loss prevention policies in Power BI
• Also on the Power BI blog, Harleen Kaur announces Announcing Public Preview of Multiple Audiences for Power BI Apps
• Chris Webb (@cwebb_bi) walks through Calling The Power BI Enhanced Refresh API From Power Automate, Part 4: Getting The Status Of a Refresh
• Ted Pattison (@TedPattison) presents Power BI Dev Camp Session 25 - Modern React-JS Development with Power BI Embedding
• Gilbert Quevauvilliers (@GilbertQue) explains How to add External (B2B) users’ access to Power BI reports
• On the Tessellation Tech blog, Spencer Baucke (@JSBaucke) explains How to Provision Access to Power BI Workspaces and Licensing and describes Enabling Azure AD SSO in Snowflake with Power BI
• Marc Lelijveld (@MarcLelijveld) explains How to add DTAP stage identifiers of to your Power BI report with Smart Narratives
• Dan English (@denglishbi) blogs about Power BI Data Driven Subscriptions with Power Automate (Report Bursting)

General

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

• Alex Powers (@notaboutthecell) announces Join members of Power BI CAT at the Power Platform Conference
• On the MSSQLTips site, Scott Murray blogs about Development Best Practices for Power BI
• James Andrew (@MatadorSoftware) talks about What is Power BI? Why Should You Learn It In 2022?

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
• Power BI Events - Interactive report displaying upcoming Power BI events worldwide, built by Matt Allington, Phil Seamark and Reid Havens
• Power BI Days - Free-to-attend virtual and in-person community events, all across the world. If you're wanting to organize an event, that's possible too - it's still free, and comes with support.