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 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
- 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
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
You Might Also Like
Bringing PGO to the build pipeline
Tuesday, April 23, 2024
Plus how Go grew at Google, cmp.Or, and ways to visualize makefiles, Go binaries, and live Go processes. | #504 — April 23, 2024 Unsub | Web Version Together with Three Dots Labs Go Weekly How Dolt
Noonification: Leetcode: Two-sum an Intuitive Approach
Tuesday, April 23, 2024
Top Tech Content sent at Noon! Get Algolia: AI Search that understands How are you, @newsletterest1? 🪐 What's happening in tech this week: The Noonification by HackerNoon has got you covered with
The best AI chatbot for coding
Tuesday, April 23, 2024
9 video gadget must-haves; 6 things Linux should borrow from MacOS -- ZDNET ZDNET Tech Today - US April 23, 2024 placeholder Can Meta AI code? I tested it against Llama, Gemini and ChatGPT - it wasn
Do I get to put your AI idea in front of 100K people?
Tuesday, April 23, 2024
If you build something great, I want to tell the world about it
UnitedHealth breach may affect huge portion of US citizens
Tuesday, April 23, 2024
The Change Healthcare ransomware attack has led to a massive leak of US healthcare data View this email online in your browser By Alex Wilhelm Tuesday, April 23, 2024 Good morning, and welcome to
LW 130 - Building a Product Configurator
Tuesday, April 23, 2024
Building a Product Configurator Shopify Development news and articles Issue 130 - 04/23/2024 Read Online Liquid Weekly All Things Shopify Development How to Sell Personalized Products on Shopify 2024 -
New public workshop in June: architecting for fast flow
Tuesday, April 23, 2024
Get the early bird discount You are receiving this email because you subscribed to the microservices.io mailing list. Helping organizations accelerate software delivery I provide consulting and
Pnpm v9.0.0; Biome v1.7; ESLint v9.1.0; Node.js collaboration summit; Intl.Segmenter; tree shaking;
Tuesday, April 23, 2024
We have 9 links for you - Stay up-to-date on JavaScript and tools WorkOS, the modern API for auth and user identity. workos.com Sponsor WorkOS enables B2B SaaS companies to accelerate enterprise
New on VC+: Our Visual Briefing on the IMF's World Economic Outlook Report 🔮
Tuesday, April 23, 2024
We've compiled a visual analysis of the most important takeaways from IMF's latest report. View email in browser EXCLUSIVE PREVIEW Upcoming on VC+: Our Key Takeaways from IMF's World
Meta teases a limited-edition, Xbox-inspired Quest headset
Tuesday, April 23, 2024
The Morning After It's Tuesday, April 23, 2024. Meta announced it's opening up the Quest's operating system to third-party companies, allowing them to build headsets of their own. The Quest