Azure Weekly - Power BI Weekly #259 - 22nd May 2024
Power BI Weekly Newsletter Issue #259
powered by endjin
Welcome to the 259th edition of Power BI Weekly! A handful of announcements and updates have been presented to us in preparation for Microsoft Build this week, and I dare say more are to come. You can find Arun's summary blog here: Unlock real-time insights with AI-powered analytics in Microsoft Fabric which includes an overview of some of the recent and upcoming innovations, and more generally, you can monitor all the Announcements on the Microsoft Fabric directly on the Fabric blog. Aside from Build, a very exciting announcement is that there is a new Microsoft Fabric Community Conference Europe to complement that which took place in Vegas a couple of months ago. It's taking place in Stockholm from September 24-27 (24th being a training day), and you can preregister now to receive a 50% discount code.
Over on the Power BI side, this week we've received the Power BI May 2024 Feature Summary, which includes new Layout modes for the Matrix visual (akin to those you get in Excel PivotTables), announces that the DAX Query View is now GA and highlights that there is now Git integration support for Direct Lake semantic models. Aside from the feature summary, Kim Manis has announced that Copilot in Microsoft Fabric is now generally available in the Power BI experience (which, for those of you that are slightly lost in all the places the term "Copilot" is being used, corresponds mainly to the Copilot pane that is docked on the right-hand-side of reports in the Power BI Service (when it is enabled)).
Elsewhere this week, Antriksh Sharma has written a detailed article about Understanding how Time Intelligence functions are evaluated in Row Context, Davide Bacci has shared his Gantt 2.0 chart offering a suite of exciting new features, and Marco Russo has shared an entertaining video on Writing DAX with ChatGPT-4o – Unplugged #58, reinforcing the fact that these LLMs need to be guided, rather than using them to do all the work for you!
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
- Rick de Groot (@Rickmaurinus) describes Understanding Enumerations in Power Query M
- Vahid Doustimajd (@VahidDoustiM) hosts Tips for Defining Custom Functions in Power Query - Omid Motamedisedeh (Persian)
- Chandeep Chhabra (@chandeep2786) describes How to Pivot Data in Power Query
- Ignacio Barrau (@ignacho_07) covers [PowerQuery] Combinar tablas de cualquier origen [Spanish]
- Reid Havens (@HavensBI) writes about Practical Azure Databricks for Power BI (with Alex Barbeau)
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Marco Russo (@marcorus) covers Writing DAX with ChatGPT-4o – Unplugged #58 and writes about Strings list to table in DAX
- On the Tabular Editor blog, Kurt Buhler (@kurtbuhler) explains how to Write DAX for a semantic model
- Antriksh Sharma (@AntrikshShar) writes about Understanding how Time Intelligence functions are evaluated in Row Context
- Reid Havens (@HavensBI) talks about Best Practices for Integrated Notes & Annotations in Power BI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Bas Dohmen (@HowToPowerBI) talks about Power BI Themes with Custom Icons, describes Extra Ranking Labels in Bar Charts and explains how to Compare to Previous in Power BI | Visual Calculations DAX
- On the Learning Science YouTube channel, Learning Science explains How to clear a slicer dynamically based on another slicer's selection in Power BI?
- On Acuity Training, Ben Richardson (@AcuityTraining) delves into Creating A Bullet Chart In Power BI
- Davide Bacci shares the Gantt 2.0 chart
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, Nikki Waghani (@NikkiWaghani) announces On-premises data gateway May 2024 release
- Chris Webb (@cwebb_bi) walks through Diagnosing Power BI DirectQuery Connection Limit Performance Problems With Execution Metrics and writes that Migrating From Power BI P-SKU Premium Capacities To F-SKU Capacities Is Not The Same Thing As Enabling Fabric
- Andrzej Leszkiewicz (@avatorl) explains how to Update Power BI Dataset (Semantic Model) More Than 8 Times a Day (Without Premium)
- Gilbert Quevauvilliers (@GilbertQue) describes Using Sempy to Authenticate to Fabric/Power BI APIs using Service Principal and Azure Key Vault
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, Jason Himmelstein (@jasehimm) shares the Power BI May 2024 Feature Summary
- Also on the Power BI blog, Arun Ulagaratchagan (@arunulag) shares Announcing Microsoft Fabric Community Conference Europe
- Also on the Power BI blog, Kim Manis (@kimmanis) writes that Copilot in Microsoft Fabric is now generally available in the Power BI experience
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 277 - Power BI & Fabric News
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
Power BI Weekly #256 - 1st May 2024
Wednesday, May 1, 2024
Power BI Weekly Newsletter Issue #256 powered by endjin Welcome to the 256th edition of Power BI Weekly! No announcements this week, so we'll jump straight into the highlighted articles. Firstly,
☁️ Azure Weekly #464 - 28th April 2024
Sunday, April 28, 2024
Azure Weekly Newsletter Issue #464 powered by endjin Welcome to issue 464 of the Azure Weekly Newsletter. In AI we have a good mix of high-level and deep-dive technical articles. Next-Gen Customer
Power BI Weekly #253 - 9th April 2024
Tuesday, April 9, 2024
Power BI Weekly Newsletter Issue #253 powered by endjin Welcome to the 253rd edition of Power BI Weekly. A couple of announcements this week. One of them has probably made itself apparent to those of
Power BI Weekly #252 - 2nd April 2024
Tuesday, April 2, 2024
Power BI Weekly Newsletter Issue #252 powered by endjin Welcome to the 252nd edition of Power BI Weekly! As the dust settles on SQLBits and FabCon, we can now reflect on the vast swathe of new Fabric
Power BI Weekly #251 - 26th March 2024
Tuesday, March 26, 2024
Power BI Weekly Newsletter Issue #251 powered by endjin Welcome to the 251st edition of Power BI Weekly. Move aside SQLBits, it's FabCon week this week, and there have already been some huge
You Might Also Like
📧 Simple Messaging in .NET With Redis Pub/Sub
Saturday, July 27, 2024
Simple Messaging in .NET With Redis Pub/Sub Read on: my website / Read time: 5 minutes BROUGHT TO YOU BY API Collaboration Has Never Been Easier API Collaboration has never been easier with
📳 Galaxy Z Flip 6 Review — How to Watch the 2024 Summer Olympics for Free
Friday, July 26, 2024
Also: Fixing Spotify's Repeating Ads, and More! How-To Geek Logo July 26, 2024 Did You Know The rectangular area of a flag found in the upper left corner (top hoist corner) of the flag, such as the
Your monthly update has arrived
Friday, July 26, 2024
What's new in Google Play and Android July 2024 The Collections surface engages users with content Introducing Collections, a new on-device surface for your content Collections present users with
iOS Dev Weekly - Issue 671
Friday, July 26, 2024
There are two types of apps on the visionOS App Store. Will you create an app that makes people reach for the headset? 🥽 View on the Web Archives ISSUE 671 July 26th 2024 Comment In the last two weeks
Ranked | The 10 Busiest Ports in the World, by Cargo Traffic 🚢
Friday, July 26, 2024
As critical nodes for trade and commercial activity, we show the top 10 busiest ports in the world by cargo volume. View Online | Subscribe Presented by: Is Your Portfolio Powering the Future? >>
Let the Games Begin
Friday, July 26, 2024
Week of July 22, 2024 Let the Games Begin Week of July 22, 2024 By MG Siegler • 26 Jul 2024 View in browser View in browser Mark Zuckerberg loves two things above all else right now: llamas and
Daily Coding Problem: Problem #1508 [Hard]
Friday, July 26, 2024
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Uber. Given an array of integers, return a new array such that each element at index i
OpenAI announces SearchGPT - Weekly News Roundup - Issue #477
Friday, July 26, 2024
Plus: Will billionaires live forever; a police robot dog jamming wireless networks; Alphabet to invest $5B into Waymo; warnings about “model collapse”; a new partnership for AI security; and more! ͏ ͏
Using Data as a Product Manager
Friday, July 26, 2024
If you had your choice between a little data or a lot of data on which to guide decisions, which would you pick?
Last Mile of Blockchains: RPC and Node-as-a-Service
Friday, July 26, 2024
Top Tech Content sent at Noon! Find the hottest jobs from top tech companies Read this email in your browser How are you, @newsletterest1? 🪐 What's happening in tech today, July 26, 2024? The