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
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]
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.