Power BI Weekly Issue 255: 23rd April 2024
This week we've had a few official updates. The first being that Copilot in Power BI will soon be available to more users in your organization, the main point being that it will be enabled by default as of May 20th (so ensure your tenant admin knows about this). We've also been told about the Deprecation of AutoML in Power BI using Dataflows V1 with the migration strategy being to use the equivalent feature in Fabric notebooks. Finally, we've been given the On-premises data gateway April 2024 release with new support for refreshes that take longer than an hour.
Elsewhere this week, Jeffrey Wang has written a fascinating blog taking us under the hood in Visual Calculations: Introducing a Two-Layer Approach in DAX Calculations, Olivier Travers has written a great overview of the various Power BI Programmatic Options: REST APIs, PowerShell, TMSL, TOM, Tabular Editor Scripting, Semantic Link, and David Eldersveld has written a short but useful piece on the Transition from Power BI Premium P SKU to Fabric F SKU: Impact of Enterprise Agreement (EA) Timeline.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- On the Power BI blog, Ancy Philip (@ancyphilip) announces the Deprecation of AutoML in Power BI using Dataflows V1
- Chandeep Chhabra (@chandeep2786) explains How to Use SUMIF or COUNTIF in Power Query
- Rick de Groot (@Rickmaurinus) discusses Formatting Dates with Custom Format Strings in Power Query M and writes about Mastering M: Which Functions to Learn and When
- Audrée Pellerin (@lecfomasque) covers Power Query : 3 trucs faciles pour optimiser et épurer vos requêtes (French)
- On the phData blog, Dave Ovitt (@phdatainc) covers Import vs Direct Query: Heres What You Need to Know
- Carl de Souza (@carldesouza) discusses Integrating Power BI Reporting with Dynamics 365 2024
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Jeffrey Wang (@jwang_pbi) writes about Visual Calculations: Introducing a Two-Layer Approach in DAX Calculations
- Patrick Leblanc (@GuyInACube) describes When Sorting Fails: Dynamic Formatting mistakes with Measures
- On the Select Distinct blog, Simon Harrison (@SelectDistLtd) writes about Comparing Year on Year in Power BI
- On the Learning Science YouTube channel, Learning Science covers Year on Year Comparison Analysis by Quarter in Power BI and blogs about Month on Month Comparison Analysis by Days in Power BI
- On the Business Intelligist blog, Business Intelligist (@bizintelligist) blogs about Price Volume Cost Mix – Gross Margin Analysis
- Yugo Shimizu (@yugoes1021) covers ディメンションの代表的な使用方法 (Typical Uses of Dimensions) (Japanese)
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the PowerPivotPro blog, Kristi Cantor (@cajuncody) discusses Power BI Visual Calculations
- Kane Snyder (@tenfingers) describes Next Level Field Parameters
- Miguel Félix covers Como criar uma tabela de field parameters em Direct Lake [Portuguese]
- On the Power BI community blog, Fowmy Abdulmuttalib (@ExcelFort) describes how to Supercharge Your Visuals: Easy Conditional Formatting in Power BI Without DAX
- Adam Saxton (@GuyInACube) talks about Wait? I can't conditionally format a Line Chart in Power BI?
- Reid Havens (@HavensBI) covers Creating a Multi-Value KPI Scorecard with a Native Bar Chart
- Chandeep Chhabra (@chandeep2786) describes 3 Insanely Awesome Slicer Tricks in Power BI
- On the xViz blog, Srushti Subhash Bachchuwar (@xvizsuite) covers Visualizing Subtree Structures: Set as Top Level in xViz Performance Flow
- On the SQL Server Central blog, Farooq Aziz discusses Identifying Customer Buying Pattern in Power BI - Part 1
- Bas Dohmen (@HowToPowerBI) discusses Do Not Create Your Design in Power BI (Here’s Why)
- Ignacio Barrau (@ignacho_07) covers [PowerBi] Catálgo de diseños para reportes [Spanish]
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, Mohammad Ali (@mohaali45) announces Copilot in Power BI: Soon available to more users in your organization
- On the Power BI blog, Nikki Waghani (@NikkiWaghani) announces On-premises data gateway April 2024 release
- Olivier Travers (@otravers) describes Making Sense of Power BI Programmatic Options: REST APIs, PowerShell, TMSL, TOM, Tabular Editor Scripting, Semantic Link
- David Eldersveld (@dataveld) covers Transition from Power BI Premium P SKU to Fabric F SKU: Impact of Enterprise Agreement (EA) Timeline
- Marc Lelijveld (@MarcLelijveld) explains how to Orchestrate Power BI Semantic model refreshes through Fabric Pipelines
- Carl de Souza (@carldesouza) discusses Integrating Power BI Reporting with Dynamics 365 (2024) and walks through Displaying Power BI Reports in Power Pages
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- Chris Webb (@cwebb_bi) discusses Power BI/Data Books Roundup
- Kurt Buhler (@kurtbuhler) covers Fabric is a team sport
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.