Power BI Weekly Newsletter Issue #223

powered by endjin

It's an abnormally short edition this week - there are almost as many links in this editorial than there are in the rest of the newsletter! Maybe everyone's still on vacation? Who knows. Anyway, the ~~Power BI~~ Fabric team has still given us a couple of articles to sink our teeth into. The first of which is the subtle but huge announcement around the all new Shareable cloud connections, which allow you to support multiple connections to the same data source and share connections with other users, which in turn lower the overhead of maintaining data connections and credentials. In real terms, this means you can now avoid the "take over and reenter credentials" shenanigans when your colleague is on holiday, and you can also configure different credentials to the same cloud data source (instead of being tied to a single set that must be reused across all datasets that connect to that data source). Effectively, cloud data sources now work very much like enterprise data gateway data sources. Woohoo!

The other official article this week is around some Best Practices to prevent GetGroupsAsAdmin API timeout, describing the patterns related to $expand and $filter to follow to try to avoid the queries timing out. Sticking to the API theme - Gerhard Brueckl has show how to Query the Power BI REST API using Fabric Spark SQL, which could be very useful if you have analytical requirements over your Power BI metadata. Finally, Teo Lachev has described Yet Another Currency Conversion Pattern to dynamically apply conversions to your monetary measures.

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 sibling 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

On the RADACAD blog, Reza Rad (@Rad_Reza) talks about Data Wrangler VS. Power Query Editor – Microsoft Fabric

Data Modeling

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

Teo Lachev (@tlachev) writes about Yet Another Currency Conversion Pattern

Report Authoring and Interactivity

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

Adam Saxton (@GuyInACube) describes A quirky Bookmark scenario with Filters in Power BI. Pay Attention!
On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) write about the Power BI Waterfall Chart: A Detailed User Guide
Daniel Marsh-Patrick (@the_d_mp) mentions that Deneb 1.6 Ready for Alpha Testing
Andrzej Leszkiewicz (@avatorl) presents IBCS-styled Column Chart in Power BI Matrix Visual | It's NOT a Custom Visual !!!

Deployment, Security and Operations

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

On the Power BI blog, Kay Unkroth (@MSPowerBI) writes about Streamlining cloud connection management for datasets, paginated reports, and other artifacts
Also on the Power BI blog, Marina Fuster shares some Best Practices to prevent GetGroupsAsAdmin API timeout
Gerhard Brueckl (@gbrueckl) discusses Querying Power BI REST API using Fabric Spark SQL
Vahid Doustimajd (@VahidDoustiM) describes how to Automatically Refresh Power BI Visuals with new Browser Extension

General

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

Adam Saxton and Patrick Leblanc (@GuyInACube) present 🔴 Microsoft Fabric/Power BI Q&A – LIVE (Sept 2, 2023)

Useful Links

Power BI Maturity Scorecard - 97% of the Fortune 500 are using Power BI. Only 20% of analytics deliver business value. How do you score?
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

Tweet | Forward | Preferences | Unsubscribe

Power BI Weekly #223 - 5th September 2023

Power BI Weekly Newsletter Issue #223

Data Prep

Data Modeling

Report Authoring and Interactivity

Deployment, Security and Operations

General

Useful Links

Older messages

☁️ Azure Weekly #434 - 3rd September 2023

Power BI Weekly #222 - 30th August 2023

☁️ Azure Weekly #433 - 27th August 2023

Power BI Weekly #221 - 22nd August 2023

☁️ Azure Weekly #432 - 20th August 2023

You Might Also Like

Import AI 399: 1,000 samples to make a reasoning model; DeepSeek proliferation; Apple's self-driving car simulator

Defining Your Paranoia Level: Navigating Change Without the Overkill

5 ways AI can help with taxes 🪄

Recurring Automations + Secret Updates

The First Provable AI-Proof Game: Introducing Butterfly Wings 4

GCP Newsletter #437

Charted | The 1%'s Share of U.S. Wealth Over Time (1989-2024) 💰

The Great Social Media Diaspora & Tapestry is here

Daily Coding Problem: Problem #1689 [Medium]

📧 Stop Conflating CQRS and MediatR