Power BI Weekly
Issue #278 - 1st October 2024
On the Power BI side, arguably the biggest news is that Dark mode is now available in Power BI Desktop, which has been a feature request probably just as long as Power BI Desktop has been around! I think it'll take a bit of getting used to, even for those who have been asking for it... We've also been told about the Enhanced Report Creation in the Power BI Service with Copilot, and been told how to Connect your data to the real world with the power of NFC and the Power BI Mobile Apps. There have also been the monthly feature summaries for both Power BI Report Server and plain old Power BI, with the standard Power BI feature summary elaborating on a couple of the points mentioned in the FabCon blog: including the new ability to have Multiple org apps per workspace (wahoo!) and being able to Live edit semantic models in Direct Lake mode with Power BI Desktop, bringing the familiar model development experience back to Desktop instead of having to do it in the browser. Much more convenient.
🛠️ Data Prep
- On the Learning Science YouTube channel, Learning Science (@learn_scitech) describes How to add Days, Weeks, Months, Quarters & Years in a date in Power Query using Power BI
🧩 Data Modeling
- On the Select Distinct blog, David Laws (@SelectDistLtd) describes DAX Calculate Function: Best Practices and Alternatives
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) discusses the Power BI DAX What If Parameter to make calculations dynamic
- On the Business Intelligist blog, Andre Fomin (@AndreFomin) describes How to Hack Your Date Dimension in Power BI
- Chandeep Chhabra (@chandeep2786) talks about Awesome Disconnected Tables Tricks in Power BI
- Parul Sagar (@parulsagar) writes A Beginner’s Guide to Implementing Semi-Additive Calculations in Power BI
- Chris Webb (@cwebb_bi) writes about Role-Playing Dimensions In Fabric Direct Lake Semantic Models
- Laura Graham-Brown (@Laura_GB) writes about Inherited Value in a Parent Child Pattern
📊 Report Authoring and Interactivity
- On the Power BI blog, Anita Ambalavanan (@MSPowerBI) announces Enhanced Report Creation in the Power BI Service with Copilot (Public Preview)
- Also on the Power BI blog, Harleen Kaur (@MSPowerBI) announces By Popular Demand: Dark mode is now available in Power BI Desktop
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) presents Dark Mode in Power BI | Interviewing Harleen Kaur from Microsoft
- Adam Saxton (@GuyInACube) describes how to Design Engaging Power BI Report Page Tooltips Effortlessly
- Reid Havens (@HavensBI) talks about Improving Value Comparisons for Line Charts
- On the SQLBI blog, Kurt Buhler (@kurtbuhler) delves into Creating custom visuals in Power BI with DAX
- Parul Sagar (@parulsagar) walks through the Key Influencers Visual: A comprehensive Look at AI-driven Insights
- Jon Stjernegaard Vöge shares a Guide: How to add Write-Back capabilities to Power BI reports with Power Apps — Part 2
🚀 Deployment, Security and Operations
- On the Power BI blog, Maya Ben Dov (@MSPowerBI) explains how to Connect your data to the real world with the power of NFC and the Power BI Mobile Apps
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) talks about Power BI Dynamic Row Level Security with Organizational Hierarchy
🌐 General
- On the Power BI blog, Jason Himmelstein (@jasehimm) announces Power BI September 2024 Feature Summary
- Also on the Power BI blog, Nirupama Srinivasan (@MSPowerBI) announces Power BI Report Server September 2024 Feature Summary