Power BI Weekly
Issue #263 - 18th June 2024
This week, we've received the Power BI June 2024 Feature Summary, which announces the introduction of the Power BI enhanced report format (PBIR) for Power BI Project files. This new report format provides source-control friendly file structures and also brings improvements to report development efficiency, enabling batch edits and copying bookmarks between reports. Additionally, there's the release of New INFO functions, Visual calculations support for scatter plots and maps, and the addition of Subfolder support in Power BI Report Builder. It is also now possible to Download large semantic models to Power BI Desktop.
Elsewhere this week, Reid Havens walked through a Different Approach to an Auto-Scaling Date Axis in Power BI, Zoe Douglas demoed the recent Power BI DAX Query View Updates June 2024, and Chandeep Chhabra explained how to Use CONCATENATEX to Create Smart Visuals in Power BI.
On the endjin side this week, my colleague Paul Waller has published a creative walkthrough video, Compelling Data Storytelling with Power BI: Titanic Survivors, exploring the creative journey behind the Titanic Passenger Diagnostic Report, showcased at SQLBits 2024. He provides insights on how to create a visually engaging and informative data story. Well worth a watch!
🛠️ Data Prep
- Chris Webb (@cwebb_bi) blogs about The “DataFormat.Error: File contains corrupted data” Error In Power Query
- On the edureka blog, Neelam Jyoti covers Query Folding in Power BI: Everything You Need to Know
- Rick de Groot (@Rickmaurinus) talks about Custom Comparer Function for Table.Group in Power Query M
- On the phData blog, Vivek Reddy Kariveda walks through Migrating Queries From Power BI Desktop to Dataflows
🧩 Data Modeling
- On the DevScope YouTube channel, Dinis Silveira (@DevScope) describes How to replicate the partition by row number function in Power BI
- On the edureka blog, Neelam Jyoti writes about What is Data Modeling in Power BI and Its Best Practices
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) talks about Power BI Default Semantic Model or Custom: A guide for using in Fabric Environment and discusses Power BI DAX Query View Updates June 2024 and Copilot Demo by Zoe Douglas
- Sam McKay (@enterprisednaco) discusses Exploring DAX Query View in Power BI
- Avi Singh (@powerbipro) explains How to Debug any DAX Measure in Power BI: Using the Breadcrumb Approach
- Philipp Lenz (@lenz_philipp) describes how to Create a TOP n Measure
- Morten Lønskov announces Tabular Editor 3: July 2024 Release
📊 Report Authoring and Interactivity
- On the endjin blog, Paul Waller (@Crashbangwaller) talks about Compelling Data Storytelling with Power BI: Titanic Survivors
- Chandeep Chhabra (@chandeep2786) describes how to Use CONCATENATEX to Create Smart Visuals in Power BI
- Reid Havens (@HavensBI) talks about Different Approach to an Auto-Scaling Date Axis in Power BI
- Bas Dohmen (@HowToPowerBI) talks about Pivot Tables in Power BI?
- On the Learning Science YouTube channel, Learning Science describes How to add or remove columns dynamically in a Power BI table or Matrix visual?
- Sunil Mathew (@sunomath7) describes Dynamic SVG icon using table visual | Native visual | Power BI Tutorial
- Miguel Félix covers Pensar dentro da caixa (novamente) [Portuguese]
- On the Business Intelligist blog, Nikil Prabhakar covers Inforiver – A No-Code Planning, Forecasting and Writeback visual
- Also on the Business Intelligist blog, Business Intelligist (@bizintelligist) talks about The Basics of Promotion Effectiveness and Category Management
🚀 Deployment, Security and Operations
- On the Power BI blog, Rui Romano (@RuiRomano) delves into Power BI enhanced report format (PBIR) in Power BI Desktop developer mode (Preview)
- Reid Havens (@HavensBI) discusses Introducing PBIR Report Format for Power BI (with Rui Romano & Eeshan Shah)
- On the phData blog, Manikanta Gudivaka (@phdatainc) writes about What Is Power BI Developer Mode and How Does it Help with Collaboration?
- Ignacio Barrau (@ignacho_07) covers Estrategia para licencias PowerBi - Fabric [Spanish]
🌐 General
- On the Power BI blog, Jason Himmelstein (@jasehimm) announces Power BI June 2024 Feature Summary
- Miguel Félix covers Atualização Power BI junho 2024 [Portuguese]
- Sam McKay (@enterprisednaco) talks about Augmenting Power BI development with Advanced Data Analysis