Power BI Weekly

Issue #161 - 14th June 2022

A pretty quiet week this week with just the one official announcement, which was the May Release of SQL Server Reporting Services 2022. An announcement from the community, however, was one from the SQLBI folks, describing how to Create your own Contoso star schema database using their new Contoso Data Generator tool to quickly generate some realistic sample data. What's more, you can bring-your-own Customers and Stores reference tables to further customize the sample data to suit your needs. Really handy tool! Elsewhere this week, Chris Webb has written an interesting blog describing How The “Maximum Connections Per Data Source” Property On Power BI DirectQuery Datasets Can Affect Report Performance, Marc Lelijveld describes Successfully implementing Power BI composite models, and Sam Fischer has shown a nice application of Field Parameters, explaining how to Swap Gantt chart hierarchies with Field Parameters.

🛠️ Data Prep

James Serra (@JamesSerra) writes about Power BI Datamarts
On the Prologika blog, Teo Lachev (@tlachev) discusses Power BI Datamarts: the Good, the Bad, and the Ugly
Chris Webb (@cwebb_bi) describes How The “Maximum Connections Per Data Source” Property On Power BI DirectQuery Datasets Can Affect Report Performance
On the Power BI community blog, Jie Zhao describes how to Extract SAP General Ledger - G/L Account Line-Item Display (T-code FBL3N) into Power BI
On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) describes Power Query: How To Merge Tables W/Different Columns
Also on the Power BI community blog, Vijay Verma writes about First Mon, Tue, Wed, Thu, Fri, Sat and Sun of the Month in Power Query Language M
Mimoune Djouallah (@mim_djo) describes Loading 1 Billion New York Taxi Dataset into Datamart

🧩 Data Modeling

Marco Russo (@marcorus) highlights a new tool: Creating your own Contoso star schema database
On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes Using KEEPFILTERS in DAX, talks about NEXTDAY, NEXTMONTH, NEXTQUARTER, NEXTYEAR, PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSYEAR – DAX Guide and discusses OPENINGBALANCEMONTH, OPENINGBALANCEQUARTER, OPENINGBALANCEYEAR – DAX Guide
Marc Lelijveld (@MarcLelijveld) writes about Successfully implementing Power BI composite models
On the Towards Data Science blog, Nikola Ilic (@DataMozart) covers Power BI Aggregations - the Ultimate Guide
Reid Havens (@HavensBI) talks about DAX Anti-Patterns Episode Eleven - Hiding Zeros - with Daniil Maslyuk
On the Power BI community blog, Vijay Verma writes about First Mon, Tue, Wed, Thu, Fri, Sat and Sun of the Month in DAX
On the Learning Science YouTube channel, Learning Science covers Running Total in Power BI using DAX
Harsh Joshi describes How To Calculate Percentages In A Hierarchical Form In Power BI

📊 Report Authoring and Interactivity

On the SQLBI blog, Marco Russo (@marcorus) describes Using SELECTEDVALUE with Fields Parameters in Power BI
On the endjin blog, Jessica Hill describes How to dynamically switch between measures in Power BI visuals with Field Parameters
On the Prologika blog, Teo Lachev (@tlachev) writes about Power BI Field Parameters
Ruth Pozuelo Martinez (@CurbalEN) covers Mastering field parameters in Power BI | A practical and common use case
Sam Fischer (@ApexInsightsPBI) describes Swapping Gantt chart hierarchies with Field Parameters
On the Blue Granite blog, Jocelyn Porter describes How Power BI Metrics and Scorecards Can Transform Productivity Within Business Objectives
Ruth Pozuelo Martinez (@CurbalEN) explains how to Learn how to create maps in Power BI | Gartner remake
On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) describes Power BI Report Builder Expressions - Date Functions
James Andrew highlights 3 Great Resources for Dashboard Design Inspiration
Ignacio Barrau (@ignacho_07) covers Una Medida para formato y navegación de botón [Spanish]
Also on the Power BI community blog, Ye Tao describes the Card Browser – A document set viewer featuring flappable

🚀 Deployment, Security and Operations

Rick de Groot (@Rickmaurinus) walks through Configuring Incremental Refresh in Power BI
Philipp Lenz (@lenz_philipp) provides A look to Power BI Goals and what you can do with Power Automate within

🌐 General

Cookie McCray announces the May Release of SQL Server Reporting Services 2022
Will Thompson (@Will_MI77) describes Driving data culture for Fairlife with Power BI
Sam McKay (@_EnterpriseDNA) presents Power BI External Tool with Greg Deckler
On the BIFocal podcast, John Patrick White and Jason Himmelstein (@BIFocalShow) present Episode 228 - Catching up on the Power BI news
Hima Bindu Marri (@sivahimabindu) shares a series: Power BI report end to end