Power BI Weekly
Issue #253 - 9th April 2024
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!
🛠️ Data Prep
- 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
- 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
- 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
- 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
- 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]