Azure Weekly - Power BI Weekly #253 - 9th April 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 you who have opened up Power BI Desktop recently, and that's the new Copilot Pane in Power BI Desktop (preview). To use this you need to have access to a workspace with an F64/P1 capacity to use as the backing compute. On the same theme, we've been provided with a Deep dive into DAX query view with Copilot, flexing some of Copilot's inline query functionality. The second announcement is on a totally different topic - and that's the support for Continuous Slide Shows in Power BI Storytelling add-in, meaning looping slide shows can have automatic refresh enabled. Aside from these official blogs this week, Marco Russo has written the much-anticipated article around Direct Lake vs. Import mode in Power BI - worth taking a read!
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
- Chris Webb (@cwebb_bi) describes Displaying Azure Maps In A Power BI Paginated Report
- Meagan Longoria (@mmarie) delves into Power Query ODBC bug affecting date calculations
- Rick de Groot (@Rickmaurinus) talks about Enumerations in Power Query, describes how to Remove Milliseconds from Time Values in Power Query and describes how to Perform Join Based on a Date Range in Power Query
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Marco Russo (@marcorus) writes about Direct Lake vs. Import mode in Power BI
- Patrick Leblanc (@GuyInACube) describes how to Boost DAX Performance in Power BI with Dual Mode
- On the Power BI blog, Zoe Douglas (@MSPowerBI) covers Deep dive into DAX query view with Copilot
- Joseph Yeates (@FthrsAnalytics) explains how to Impute Future Values with ALLSELECTED()
- Chandeep Chhabra (@chandeep2786) describes How to Apply Custom Sorting in Power BI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Power BI blog, Harleen Kaur (@MSPowerBI) introduces the Introducing Copilot Pane in Power BI Desktop (preview)
- On the SQLBI blog, Kurt Buhler (@kurtbuhler) discusses Using scatterplots to find details in reports
- Fowmy Abdulmuttalib (@ExcelFort) describes Power BI Dynamic Date Filters: Automatically Updating Filters with Each Refresh
- On the Learning Science YouTube channel, Learning Science describes How to hide a column in Power BI for the Table visual
- Mudassir Ali (@EnterpriseDNA_) explains how to Create Beautiful Report Templates with PowerPoint
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Reid Havens (@HavensBI) discusses Managing Power BI, to Prepare for Fabric (with Alex Whittles)
- Patrick Leblanc (@GuyInACube) talks about Wait it’s the same data source! What’s going on?
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, Maya Shenhav (@MSPowerBI) talks about Supporting continuous Slide Shows in Power BI Storytelling add-in
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) share Fabric and Power BI Auckland User group recording - Fabric CAT Updates of Fabric Conference
- Bas Dohmen (@HowToPowerBI) walks through Complete Project with Power BI, Power Apps, Power Automate and Dataverse
- Miguel Félix covers Atualização Power BI março 2024 [Portuguese]
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 #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
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
You Might Also Like
JSK Daily for Oct 5, 2024
Saturday, October 5, 2024
JSK Daily for Oct 5, 2024 View this email in your browser A community curated daily e-mail of JavaScript news Understanding CommonJS vs. ES Modules in JavaScript JavaScript has undergone significant
🪟 How to Prevent Windows 10/11 From Locking Itself — Biggest Tech Fails
Saturday, October 5, 2024
Also: Does Airplane Mode Speed Up Charging, and More! How-To Geek Logo October 5, 2024 Did You Know The idea that camels store water in their humps to survive long treks through the desert is a
Issue #561: js13kGames 2024 winners, OneJS, and Nadine's Fleet II
Saturday, October 5, 2024
View this email in your browser Issue #561 - October 5th 2024 Weekly newsletter about Web Game Development. If you have anything you want to share with our community please let me know by replying to
Ranked | The Worst Cities for Rush Hour Traffic 🚗
Saturday, October 5, 2024
We look at the worst cities for rush hour traffic, both globally and in the US specifically. View Online | Subscribe | Download Our App Presented by Voronoi: The App Where Data Tells the Story FEATURED
⚙️ Special Edition: Eric Xing and the Age of AI Empowerment
Saturday, October 5, 2024
We met up with Dr. Eric Xing to talk about the realities of AI.
🐍 New Python tutorials on Real Python
Saturday, October 5, 2024
Hey there, There's always something going on over at Real Python as far as Python tutorials go. Here's what you may have missed this past week: Python 3.13: Cool New Features for You to Try In
Hooked On Clarendon 💡
Saturday, October 5, 2024
The very common font that kicked off a redesign. Here's a version for your browser. Hunting for the end of the long tail • October 05, 2024 Hooked On Clarendon I saw a font recently, and it
Largest-Ever DDoS Attack Just Occurred—3.8 Tbps in Just 65 Seconds!
Saturday, October 5, 2024
THN Daily Updates Newsletter cover Mastering Spring Boot 3.0 ($31.99 Value) FREE for a Limited Time A comprehensive guide to building scalable and efficient backend systems with Java and Spring
Re: No more spam!
Saturday, October 5, 2024
If you are tired of getting spam texts and phone calls, I have a new discovery that you need to read about. It's a service called Incogni, and I'd recommend it to any iPhone Life reader
📧 Implementing the Outbox Pattern
Saturday, October 5, 2024
Implementing the Outbox Pattern Read on: my website / Read time: 8 minutes The .NET Weekly is brought to you by: Visually Building API-Driven Applications with Postman Flows Explore how Postman