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
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- 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
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- 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
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- 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
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- 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
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- 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
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.