Azure Weekly - Power BI Weekly #250 - 20th March 2024
Power BI Weekly Newsletter Issue #250
powered by endjin
Welcome to the 250th edition of Power BI Weekly! SQLBits is upon us - I hope a good number of you have been fortunate enough to attend this year. If anyone reading this is attending, I'll be here all week, so please come and say hi.
Outside SQLBits, there's been a pretty significant announcement this week in the Power BI space, and that's the Upcoming Retirement of Power BI Premium P SKUs (for everyone apart from sovereign cloud customers). I can't say this is a huge surprise (what with the new Fabric SKUs) but it's something you should start planning for sooner rather than later.
Some other announcements this week include the On-premises data gateway March 2024 release, in which we've been told about the Service Principal (SPN) support for on-premises and VNET data gateways. We've also been given some Copilot Updates March 2024, containing some admin updates and the announcement of added support for Apps, allowing report consumers to interact with Copilot as they browse app artifacts.
Sticking on the Copilot theme, Chris Webb has written a helpful blog discussing How Much Does Copilot Cost In Microsoft Fabric?, pointing out how that's not actually the right question to ask. Alberto Ferrari has written the first SQLBI blog on visual calculations, introducing VISUAL SHAPE for visual calculations in Power BI. Finally, my colleague Paul has written a brilliant in-depth blog about How to Build Visually Appealing and User Friendly Navigation into Power BI.
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
- Adam Saxton (@GuyInACube) explains how Include in Refresh can trip you up within Power Query
- On the Learning Science YouTube channel, Learning Science explains How to merge multiple sheets into one while loading data in Power Query using Excel or Power BI?
- On the RADACAD blog, Reza Rad (@Rad_Reza) delves into Copilot in Power Query in Power BI Service and Microsoft Fabric Dataflow Gen2
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) talks about Introducing VISUAL SHAPE for visual calculations in Power BI
- On the Power BI community blog, Ignacio Barrau (@ignacho_07) describes [DAX] Time Intelligence vs WINDOW vs OFFSET
- On Acuity Training, Maximillian Hindley writes about 6 Best Practices for Efficient Data Modeling in Power BI
- Chandeep Chhabra (@chandeep2786) describes How to Create One to Many Relationship in Power BI
- On the Business Intelligist blog, Business Intelligist (@bizintelligist) describes How to generate Business Friendly Power BI Data Dictionary using Open AI Semantic Link
- On the Power BI community blog, Yifan Wang describes how to Display data in a fixed order and show data for the top three selections
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Reid Havens (@HavensBI) describes Dynamic Column Headers (with Field Parameters) in Power BI
- On the endjin blog, Paul Waller (@Crashbangwaller) explains How to Build Navigation into Power BI
- On the Learning Science YouTube channel, Learning Science explains how to Calculate a running sum or running total at visual level without using DAX measures in Power BI
- Binbin Yu covers Dynamic filtering of two tables based on one slicer
- On the Select Distinct blog, Simon Harrison (@SelectDistLtd) explains How to Sync Slicers in Power BI
- On Acuity Training, Ben Richardson (@AcuityTraining) covers Decomposition Tree Visuals – Quick Guide
- Oscar Martínez Valero (@OValerock) talks about Rethinking Dashboard Design
- Nidhi Srinath (@TDataScience) covers Creating Interactive Power BI Dashboards That Engage Your Audience
- Nidhi Srinath (@TDataScience) describes Creating Interactive Power BI Dashboards That Engage Your Audience
- Ben Richardson (@AcuityTraining) writes about the Decomposition Tree Visuals - Quick Guide
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, Kim Manis (@kimmanis) announces Important update coming to Power BI Premium licensing
- Also on the Power BI blog, Nikki Waghani (@NikkiWaghani) shares the On-premises data gateway March 2024 release
- Chris Webb (@cwebb_bi) writes about How Much Does Copilot Cost In Microsoft Fabric?
- Mihály Kávási (@KavasiM) explains How to find which visual generated the query in Log Analytics?
- Marcus Wegener (@PowerBIler) covers Power BI Verwendungsszenario – Unternehmens-BI [German]
- Soheil Bakhshi (@biinsightnz) discusses Microsoft Fabric: Source Control Options for Power BI Developers
- Pat Mahoney (@mahoneypa) discusses Power BI Semantic Model Snapshots With A Fabric Notebook
- Kevin Arnold (@kevarnold) shares some Scripts to improve copying a Direct Lake semantic model to another workspace using Microsoft Fabric Git integration locally
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the Power BI blog, Mohammad Ali (@mohaali45) shares Copilot Updates March 2024
- Chandeep Chhabra (@chandeep2786) talks about My Top 5 Power BI Mistakes (and how to avoid them)
- On myOnlineTraininghub, Mynda Treacy (@OnlineTrainingH) discusses Power BI Tutorial for Excel Users
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 273 - Interview with Alex Powers
- Matt Allington (@ExceleratorBI) presents My Latest Podcast with Rob Collie from P3 Adaptive
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
- PowerQuery How - Alternative M Language Reference created by Rick de Groot, including improved function explanations, code formatting, practical examples and further reading
- 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
Older messages
☁️ Azure Weekly #457 - 10th March 2024
Sunday, March 10, 2024
Azure Weekly Newsletter Issue #457 powered by endjin Welcome to issue 457 of the Azure Weekly Newsletter! In order to tackle the increasing volumes of spam and phishing emails, various email providers
☁️ Azure Weekly #456 - 3rd March 2024
Sunday, March 3, 2024
Azure Weekly Newsletter Issue #456 powered by endjin Welcome to issue 456 of the Azure Weekly Newsletter. A varied selection of articles this week. Let's start with AI; Fine Tuning with Function
Power BI Weekly #247 - 27th February 2024
Tuesday, February 27, 2024
Power BI Weekly Newsletter Issue #247 powered by endjin Welcome to the 247th edition of Power BI Weekly! A flurry of announcements came shortly after last week's edition, and it's not really
Power BI Weekly #246 - 20th February 2024
Tuesday, February 20, 2024
Power BI Weekly Newsletter Issue #246 powered by endjin Welcome to the 246th edition of Power BI Weekly! We're still awaiting the first Power BI feature summary of the year, but from what I can
☁️ Azure Weekly #454 - 18th February 2024
Monday, February 19, 2024
Azure Weekly Newsletter Issue #454 powered by endjin Welcome to issue 454 of the Azure Weekly newsletter. Another mixed bag this week with a variety of interesting posts across all categories. This
You Might Also Like
Re: You're Invited: Free Photo Management Class
Tuesday, March 11, 2025
This is your last chance to register for tomorrow's live online Photo Management Class, Wednesday, March 12, at 4:30 pm ET! Sign up now to attend the FREE Photo Management Class The recent changes
BetterDev #275 - Tracking You from a Thousand Miles Away! Turning a Bluetooth Device into an Apple AirTag Without Root Privileges
Monday, March 10, 2025
Better Dev #275 Mar 10, 2025 Hi all, In the wave of ByBit exchange being hack for 1.6billion, and the hack is very sophisciated, exploit developer access key to change an s3 bucket. The attack start by
What's the goal of the goal & Tapbots is working on a Bluesky client
Monday, March 10, 2025
Capacities releases rewritten PDF viewer and new AI editor, Ghost teases larger update for its ActivityPub integration, clear communication, and more in this week's issue of Creativerly.
Ranked: | The World's Most Popular Programming Languages 🖥️
Monday, March 10, 2025
In 2024, Python surpassed JavaScript as the most popular programming language on GitHub for the first time. View Online | Subscribe | Download Our App Invest in your growth at Exchange 2025. FEATURED
GCP Newsletter #441
Monday, March 10, 2025
Welcome to issue #441 March 10th, 2025 News Infrastructure Official Blog Hej Sverige! Google Cloud launches new region in Sweden - Google Cloud has launched its 42nd cloud region in Sweden, providing
⚡ THN Weekly Recap: New Attacks, Old Tricks, Bigger Impact
Monday, March 10, 2025
State-sponsored hacking, IoT botnets, ransomware shifts—this week's cyber roundup covers it all. Stay informed, stay secure. Read now ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Beware AI voice cloning tools 🤖
Monday, March 10, 2025
Linux for your phone; Warner Bros. DVDs rot; GCal gets Gemini -- ZDNET ZDNET Tech Today - US March 10, 2025 Voice waveforms Most AI voice cloning tools aren't safe from scammers, Consumer Reports
⚙️ Google's AI plans
Monday, March 10, 2025
Plus: The DeepSeek alarm bells
Post from Syncfusion Blogs on 03/10/2025
Monday, March 10, 2025
New blogs from Syncfusion ® Convert PowerPoint to PDF in C# Using Advanced Formatting Options By Mohanaselvam Jothi Learn how to convert PowerPoint presentations to PDF with advanced options using the
😎 10 Weirdest Android Phones Ever — Why I Prefer Bixby to Google Assistant
Monday, March 10, 2025
Also: 3 Awesome Shows to Watch After "Fallout", and More! How-To Geek Logo March 10, 2025 Did You Know Despite their dog-like appearance, hyenas are more similar, phylogenetically speaking,