Azure Weekly - Power BI Weekly #252 - 2nd April 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 announcements and their impact (if any) on our businesses. I shared Arun's main blog last week: Announcements from the Microsoft Fabric Community Conference, but if a wall of words isn't for you, it might be easier looking through the latest posts on the Fabric blog to get an idea of the top-level updates and announcements. The main announcements impacting Power BI users, in my opinion, would be
- Announcing Folder in Workspace in Public Preview - Folders for Fabric artifacts! Although currently
.pbix
files have to be manually uploaded to a target folder. (Apparently publishing to a folder from Power BI Desktop will arrive in the next few months.) - Announcing the Public Preview of Database Mirroring in Microsoft Fabric - Mirroring automatically replicates your database data into your tenant's OneLake. Currently only supported for Azure Cosmos DB, Azure SQL DB and Snowflake.
- Get data with Power Query available in Power BI Report Builder (Preview) - Paginated Reports can now connect to hundreds of data sources using the Power Query Editor we know and love from Power BI Desktop.
Elsewhere this week, Carly Newsome has joined Adam at GuyInACube to discuss Copilot for Power BI: Your Ultimate Copilot Guide, Alberto Ferrari has continued the visual calculations series with Introducing EXPAND and COLLAPSE for visual calculations in Power BI, and Reid Havens has explained the difference between Explosion Vs Erosion for Stacked Charts in 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
- Rick de Groot (@Rickmaurinus) highlights the release of the new book: The Definitive Guide to Power Query M
- On the Power BI blog, Nirupama Srinivasan (@MSPowerBI) explains how to Get data with Power Query available in Power BI Report Builder (Preview)
- Chris Webb (@cwebb_bi) covers Power BI Paginated Reports That Connect To Web Services And Excel
- Chandeep Chhabra (@chandeep2786) explains how to Connect Excel / CSV files from SharePoint to Excel or Power BI
- Fowmy Abdulmuttalib (@ExcelFort) writes about Enhanced Data Profiling in Power Query: GUI and Table.Profile Function with 2nd Argument
- Paul Turley (@paul_turley) covers Power BI Direct Lake and DirectQuery in the Age of Fabric
- Michael Kovalsky writes about Direct Lake Migration
- Luca Liu describes Two ways to Union Tables - DAX and Power Query
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Chandeep Chhabra (@chandeep2786) describes How to Create a Bridge Table for Many to Many Relationships
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) explain How to Use Switch True Logic in Power BI
- Antriksh Sharma (@AntrikshShar) provides a CALCULATE Deep Dive
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) introduces EXPAND and COLLAPSE for visual calculations in Power BI
- Reid Havens (@HavensBI) describes Explosion Vs Erosion for Stacked Charts in Power BI
- Xinyi X covers How to use Tooltip to display breakdown data for a specified ranking
- On the Learning Science YouTube channel, Learning Science describes How to dynamically change the values of the X axis and Y axis in a chart in Power BI
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Patrick Leblanc (@GuyInACube) discusses Exploring Dynamic Subscriptions for Power BI reports
- Philipp Lenz (@lenz_philipp) writes about Dynamic subscriptions with email in Power BI / paginated reports – Part 2
- On the Purple Frog Systems blog, Tom Owen (@PurpleFrogSys) describes Deployment Pipelines in Power BI and Fabric
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- Adam Saxton (@GuyInACube) talks about Copilot for Power BI: Your Ultimate Copilot Guide (with Carly Newsome)
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 #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
Power BI Weekly #250 - 20th March 2024
Wednesday, March 20, 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.
☁️ 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
You Might Also Like
💻 Issue 333 - React 19 Beta
Thursday, May 2, 2024
This week's Awesome React Weekly Read this email on the Web The Awesome React Weekly Issue » 333 Release Date May 02, 2024 Your weekly report of the most popular React news, articles and projects
📱 Issue 412 - The Composable Architecture: My 3 Year Experience
Thursday, May 2, 2024
This week's Awesome Swift Weekly Read this email on the Web The Awesome Swift Weekly Issue » 412 Release Date May 02, 2024 Your weekly report of the most popular Swift news, articles and projects
💻 Issue 410 - Lessons learned after 3 years of fulltime Rust game development, and why we're leaving Rust behind
Thursday, May 2, 2024
This week's Awesome Rust Weekly Read this email on the Web The Awesome Rust Weekly Issue » 410 Release Date May 02, 2024 Your weekly report of the most popular Rust news, articles and projects
📺 How to Stop Any Smart TV From Spying On You — Single Player Games That Are Fun With Friends
Thursday, May 2, 2024
Also: Alienware's Latest Gaming Laptop is Great For Work, and More! How-To Geek Logo May 2, 2024 Did You Know The voice actors behind Mickey and Minnie Mouse throughout the 1980s, 1990s, and most
JSK Daily for May 2, 2024
Thursday, May 2, 2024
JSK Daily for May 2, 2024 View this email in your browser A community curated daily e-mail of JavaScript news What is Throttling in JavaScript? Explained with a Simple React Use Case Welcome back,
Issue 315 - Look ma, tight parallel park, no radar!
Thursday, May 2, 2024
View this email in your browser If you are just now finding out about Tesletter, you can subscribe here! If you already know Tesletter and want to support us, check out our Patreon page Issue 315 -
Full-Stack .NET Development, Creating Reactive Applications in .NET, More
Thursday, May 2, 2024
Home | News | How To | Webcasts | Whitepapers | Advertise .NET Insight May 2, 2024 THIS ISSUE SPONSORED BY: ■ How to Build Interactive Blazor Apps with WebAssembly ■ VSLive! Hands-On Virtual Training
Daily Coding Problem: Problem #1429 [Easy]
Thursday, May 2, 2024
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Sumo Logic. Given a array that's sorted but rotated at some unknown pivot, in which
Ranked | Which Country Has the Most Billionaires in 2024? 💰
Thursday, May 2, 2024
According to the annual Hurun Global Rich List, the US and China are home to nearly half of the world's 3279 billionaires in 2024. View Online | Subscribe Presented by: The economy is changing. Is
⚙️ Rovo
Thursday, May 2, 2024
Plus: Microsoft are (were?) terrified of Google's AI