Power BI Weekly Issue 52: 31st March 2020
There have been a number of announcements in the past week, possibly the most exciting of which is that of the public preview of the read/write XMLA endpoints in Power BI Premium / Embedded, providing much more flexibility around dataset management, debugging, testing etc. Also announced this week is the General Availability of Query Diagnostics, the new Performance Improvements for Multi Geo Premium Capacities, and the New Gateway management features on Power Platform Admin Center.
Elsewhere this week, Soheil Bakhshi has written about Highlighting Below Avg Sales per Hierarchy Level with SWITCH() and ISINSCOPE() DAX Functions in Power BI, Marco Russo has written about Controlling Format Strings in Calculation Groups, and Adam Saxton has described how to Make navigation easier with Power BI buttons.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- On the Power BI blog, Colin Popell announces the General Availability of Query Diagnostics
- Cédric Charlier (@Seddryck) blogs about Parsing COVID-19 files from John Hopkins University with Power Query/M
- On the BI Elite blog, Parker Stevens (@PowerBIElite) writes about Recursive Calculations with Python in Power BI
- Lars Schreiber (@SchreiberLars) writes Tageswerte aus kumulierten Werten berechnen [German]
Data Modeling
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- The SQL Data Partners podcast team (@sqldatapartners) presents Episode 195: Understanding DAX with DesertIsleSQL
- Soheil Bakhshi (@biinsightnz) describes Highlighting Below Avg Sales per Hierarchy Level with SWITCH() and ISINSCOPE() DAX Functions in Power BI
- On the SQLBI blog, Marco Russo (@marcorus) describes Controlling Format Strings in Calculation Groups
- Chandeep Chhabra (@chandeep2786) talks about Sort by Column in Power BI – Examples
- Patrick Leblanc (@GuyInACube) describes Using Precedence to force Power BI Aggregations
- On the Power BI community blog, gbrunnerbi writes about a Custom Fiscal Calendar with Pre-Defined Date Ranges
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a number of blogs: Filtering Data By Custom Fiscal Years And Quarters Using Calculated Columns In Power BI, Data Segmentation Based On Percentage Groups – Advanced DAX In Power BI, How To Create A Dynamic Power BI Report, Identify & Showcase Data Outliers In Power BI Using DAX, Creating Power BI Tables By Using UNION & ROW Function and How To Use SWITCH True Logic In Power BI
Report Design and Visualizations
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes about the Power BI Shape Map Visualization For Spatial Analysis
- Sophie Marchand (@Mon_Cher_Watson) writes about COVID-19: Construisez vos propres analyses sur cartes géographiques dynamiques (2 de 2) [French]
Data Exploration
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- On the Power BI community blog, Sam McKay (@_EnterpriseDNA) presents Some Ideas and Techniques for Customer Churn Analysis in Power BI
- Also on the Power BI community blog, Greg Deckler (@GregDeckler) shares Power BI Dashboards for Dynamics 365 Finance & Operations via the Common Data Service - Part 3 and Part 4
- Gil Raviv (@gilra) blogs about COVID-19: Build your own Power BI dashboard – Revised
- On the Towards Data Science blog, Shankar Lakshmanan blogs about COVID-19—Interactive Power BI Map of Total Cases by US State and County
- Adam Saxton (@GuyInACube) explains how to Make navigation easier with Power BI buttons
Deployment, Security and Operations
Covering: Apps and App Workspaces, Template Apps, Datasets, Gateways, Security, Sharing, Licences, REST APIs, PowerShell cmdlets, .NET SDK
- On the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) announces the New Gateway management features on Power Platform Admin Center
- Also on the Power BI blog, David Magar announces the Announcing Performance Improvements for Multi Geo Premium Capacities
- On the MSSQLTips site, Scott Murray discusses Power BI Table Based Row Level Security
- Adam Saxton (@GuyInACube) describes Using Single Sign-on with the Power BI Gateway
- Marcus Wegener (@PowerBIler) writes about Incremental refresh with subqueries
- On the Blue Granite blog, Josh Crittenden (@Jcrit44) writes about Three Reasons to Consider Power BI Premium
General
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- On the Power BI blog, Christian Wade (@_christianWade) announces the read/write XMLA endpoints in Power BI Premium public preview
- Also on the Power BI blog, Miguel Martinez (@maikelson) describes how to Help improve Power BI – Performance
- On the Power BI blog, Sandy Rivas (@SandyRivas) writes that the ‘Better Together’ Contest Finalists Announced!
- Adam Saxton (@GuyInACube) discusses the Power BI updates, tips and Coronavirus... (Roundup | March 23, 2020)
- Devin Knight (@knight_devin) talks about Power BI Monthly Digest – March 2020 with Matt Peterson
- On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) blogs about the Milwaukee Brew City PUG – Feb 2020
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.