Power BI Weekly Newsletter Issue #171

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

• Microsoft Power BI (@MSPowerBI) describes how to Access and transform data with Power BI Datamart
• Chris Webb (@cwebb_bi) describes Calling The Power BI Enhanced Refresh API From Power Automate, Part 3: Incremental Refresh Options
• On the Power BI community blog, Jay Wang explains how to Calculate Row Total and Column Total in Power Query
• Chandeep Chhabra (@chandeep2786) describes 2 Navigation Tricks in Power Query
• Melissa de Korte (@_EnterpriseDNA) explains How To Use Custom Grouping and Ranking In Power Query
• Lars Schreiber (@SchreiberLars) covers So trennst du buchstaben und ziffern von sonderzeichen mit Power Query [German]
• Avi Singh (@powerbipro) describes 3 Easy Ways to Create Your Power BI Calendar Table / Date Table
• James Andrew (@MatadorSoftware) describes how to Use SQL Views to Improve your Power BI Experience
• Gaelim Holland (@_EnterpriseDNA) describes How To Translate Texts Using Python For Power BI

Data Modeling

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

• On the Power BI blog, Kay Unkroth (@MSPowerBI) announces Power BI paves the way for smooth Azure Analysis Services migrations
• Jeffrey Wang (@jwang_pbi) introduces Intoducing the DAX EVALUATEANDLOG Function and describes how to Understand the Output of EVALUATEANDLOG Function of Scalar Expressions
• On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) describes Power BI Modelling Basics Part One and talks about Power BI Modelling Using Power Query Part Two
• James Andrew (@MatadorSoftware) describes Simply Explaining Data Model Relationships in Power BI | With Real World Examples
• Audrée Pellerin covers Langage DAX: calculer le nombre de jours entre 2 dates [French]
• Also on the MSSQLTips site, Kenneth A. Omorodion blogs about Calculating Work Days for Power BI Reports using NETWORKDAYS Function
• Marco Russo (@marcorus) covers Computing sales made to customers before and after a period

Report Authoring and Interactivity

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

• On the RADACAD blog, Reza Rad (@Rad_Reza) covers Power BI Paginated Report – Perfect for Printing
• On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) talks about Power BI Paginated Report Perfect for Printing
• On the Enterprise DNA blog, Brian Julius (@_EnterpriseDNA) describes Power BI Slicers Tutorial: Counting Selections Correctly
• Daniel Marsh-Patrick (@the_d_mp) describes Making "The Mundigl Bullets" with Deneb
• Erik Svensen (@donsvensen) describes #PowerBI Convert all Power BI links in Power Point to images
• Patrick Leblanc (@GuyInACube) discusses Refresh and no data in my Power BI visuals?
• Adam Saxton (@GuyInACube) explains how to Get creative with buttons in Power BI
• On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) describes How to Visualize Python Charts in Power BI and discusses Tips to improve Power BI report appeal
• Reid Havens (@HavensBI) covers Upgrading Report Performance with Report Page Tooltips
• Also on the SQL Server Central blog, Kenneth A. Omorodion delves into Power BI Dynamic X and Y Axis Using Groupings in Field Parameters
• Chandeep Chhabra (@chandeep2786) describes how to Create Dynamic Tooltips Using Field Parameter in Power BI
• Matt Allington (@ExceleratorBI) writes about Power BI Live Embedding In PowerPoint
• Bas Dohmen (@HowToPowerBI) describes New Improved Formatting of Data Labels in Power BI
• Hima Bindu Marri (@sivahimabindu) covers Paginated Report vs Power BI Report | Power BI interview questions | Power BI for beginners
• Ignacio Barrau (@ignacho_07) covers [PowerBi] Haciendo dark theme en reportes [Spanish]
• On the MSSQLTips site, Scott Murray blogs about Development Best Practices for 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, Nikki Waghani (@NikkiWaghani) announces On-premises data gateway August 2022 update is now available
• On the Power BI community blog, Ted Pattison (@TedPattison) announces Modern React-JS Development with Power BI Embedding
• On the Towards Data Science blog, Nikola Ilic (@DataMozart) covers The Ultimate Guide to Row-Level and Object-Level Security in Power BI
• On the Tessellation Tech blog, Spencer Hamilton writes about What is the Price of Power BI Premium and What SKU Should you Choose?
• On the Power BI community blog, Yang Liu describes how to How to get the latest sign-in data for each user within your tenant

General

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

• Sam McKay (@_EnterpriseDNA) announces Upcoming Business Intelligence Summit 2022 - Our Biggest Event To Date
• Reid Havens (@HavensBI) talks about Enterprise-Grade Planning at Scale using Acterys in Power BI (with Martin Kratky)
• On the BIFocal podcast, John Patrick White and Jason Himmelstein (@BIFocalShow) present Episode 233 - Power BI August 2022 Feature Summary
• Michael Felix covers Atualização Power BI Agosto 2022 [Portuguese]

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.