Azure Weekly - Power BI Weekly #161 - 14th June 2022

Power BI Weekly Newsletter Issue #161

powered by endjin

Welcome to the 161st edition of Power BI Weekly! 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.

If you have any content you'd like to contribute to the newsletter, please tweet @PowerBIWeekly or ping an email to

Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news.

@edfreeman_ | @endjin |

Data Prep

Covering: Power Query (M), Dataflows, Data connectors, AI Insights

Data Modeling

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

Report Authoring and Interactivity

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

Deployment, Security and Operations

Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling


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

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.

Tweet  |  Forward  |  Preferences  |  Unsubscribe

Older messages

Power BI Weekly #160 - 7th June 2022

Tuesday, June 7, 2022

Power BI Weekly Newsletter Issue #160 powered by endjin Only one update this week, which is that Enhanced refresh with the Power BI REST API is now generally available (renamed from asynchronous

☁️ Azure Weekly #373 - 29th May 2022 - Microsoft BUILD special!

Monday, May 30, 2022

Azure Weekly Newsletter Issue #373 powered by endjin Welcome to issue 373 of Azure Weekly - a bumper edition (about 2x the normal size!) covering all the announcements from BUILD 2022. Jumping straight

☁️ Azure Weekly #372 - 22nd May 2022

Sunday, May 22, 2022

Azure Weekly Newsletter Issue #372 powered by endjin Welcome to issue 372 of Azure Weekly! Quite a busy edition this week, considering this is usually the "calm before the BUILD storm". Some

Power BI Weekly #157 - 17th May 2022

Tuesday, May 17, 2022

Power BI Weekly Newsletter Issue #157 powered by endjin Welcome to the 157th edition of Power BI Weekly! Yesterday the Power BI May 2022 Feature Summary came out, and the feature that's drawn the

Power BI Weekly #156 - 10th May 2022

Tuesday, May 10, 2022

Power BI Weekly Newsletter Issue #156 powered by endjin Welcome to the 156th edition of Power BI Weekly! This week we've been told about the New data source and gateway management experience (which

♦️⚡️♦️ Databricks' New ML Announcements

Sunday, July 3, 2022

Databricks has been one of the companies that have been at the center of the big data movement, pioneering technologies such as Apache Spark. Machine learning (ML) has been a native component of Spark

MuteMe button/Quick Clot/Podchaser

Sunday, July 3, 2022

Recomendo Recomendo July 3 · Issue #313 · View online A weekly newsletter that gives you 6 brief personal recommendations of cool stuff. For a searchable archive of past issues check out https://

Kotlin Weekly #309

Sunday, July 3, 2022

ISSUE #309 3rd of July 2022 Hello from Italy Kotliners (where the weather forecast has been everything but right). The KotlinConf has been finally announced, and the early and super early tickets are

[Python Mastery] The hidden costs of "copy-paste" Python programming

Sunday, July 3, 2022

Hey there, Here's a development story that plays out thousands of times each day: Avid Pythonista Max is working on a function to find the 10 oldest files in a nested directory hierarchy. He needs

Weekend Reading — Just hacks all the way down

Sunday, July 3, 2022

This week we ride on one and two half wheels, design a responsive snake, locate our headphones, and dance to the ring tone. Weekend Reading — Just hacks all the way down By Assaf Arkin – 02 Jul 2022 –

There are no open issues or pull requests on Flask — Learn TLA+ — and The GPU shortage is over

Saturday, July 2, 2022

Issue #816 — Top 20 stories of July 03, 2022 Issue #816 — July 03, 2022 You receive this email because you are subscribed to Hacker News Digest. You can open it in the browser if you prefer. 1 There

JSK Daily for Jul 2, 2022

Saturday, July 2, 2022

JSK Daily for Jul 2, 2022 View this email in your browser A community curated daily e-mail of JavaScript news Angular State Management with NgRx State management is the process of managing the states

Daily Coding Problem: Problem #806 [Hard]

Saturday, July 2, 2022

Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Google. Let A be an N by M matrix in which every row and every column is sorted. Given i

Infographic | A Logarithmic Map of the Entire Observable Universe 🌌

Saturday, July 2, 2022

Scientists believe we've only discovered about 5% of the universe. Here's a map of what we've found so far, visualized using a log scale. View Online | Subscribe Presented by: Do You

What Are the Best Nintendo Switch Games in 2022?

Saturday, July 2, 2022

Did You Know?: Before it was destroyed at the end of February 2022, the cargo hold of the world's largest cargo plane, the Antonov An-225 Mriya, was 142 feet 2 inches (43.35 meters) in length—22