Power BI Weekly
Issue #284 - 12th November 2024
Some pretty significant updates this week. First of all, Microsoft has announced it is increasing the cost of Power BI Pro from $10 to $14 and PPU from $20 to $24 from April 1 2025. Quite a big increase, but let's remember that the price for Pro has stayed the same for the last 10 years. Still, a massive change that needs to be planned and budgeted for. Aside from this news, we've also been given the Power BI November 2024 Feature Summary (maybe to sweeten the news?). The main update in here is the new Copilot in Power BI Mobile Apps (Preview) (similar to the Power BI Service experience), but there's also the new Small multiples for the new card visual (Preview) and Metric sets: a new era of metric management in Fabric (Preview) among many other updates - do check it out.
🛠️ Data Prep
- Ayushi Jain discusses Data Cleaning and Preprocessing with Power Query Editor in Power BI
- Audrée Pellerin (@lecfomasque) covers Intelligence artificielle dans Power BI : Insights sur texte [French]
- Shivanshu Bisht shares Dynamic Column Part 1 - PQ
- Paul Turley (@paul_turley) writes about Direct Lake memory: hotness, popularity & column eviction
- Rick de Groot (@Rickmaurinus) describes How to Replace Multiple Substrings in Power Query M
🧩 Data Modeling
- Chris Webb (@cwebb_bi) covers Tuning Power BI Copilot With Summarize By
- Vahid Doustimajd (@VahidDoustiM) talks about Visual Calculations [Persian]
- Parul Sagar (@parulsagar) writes Is It Count or Countrows? Let’s Clear Up the Confusion with Key Insights!
📊 Report Authoring and Interactivity
- On the SQLBI blog, Kurt Buhler (@kurtbuhler) talks about Building bullet charts in Power BI reports
- Marcus Wegener (@PowerBIler) describes Fun with Flags – Country Emojis as Data Labels in Power BI
- On the Business Intelligist blog, Nikil Prabhakar walks through Enhancing Collaboration in Power BI with Advanced Commenting Features
- On the Learning Science YouTube channel, Learning Science (@learn_scitech) explains How to use a slicer visual as both a data card and slicer in Power BI | Power BI New button slicer
- Parul Sagar (@parulsagar) describes how to Jumpstart Your Power BI Visuals with R: Quick and Easy Tips
🚀 Deployment, Security and Operations
- Jon Stjernegaard Vöge writes about First look at the new Organizational Apps for Power BI / Fabric – Reflections and Usage Pattern Ideas
- Bas Dohmen (@HowToPowerBI) explains how to Protect Your Power BI Items
- Ignacio Barrau (@ignacho_07) covers [Fabric] Como administrar una sana capacidad [Spanish]
🌐 General
- On the Power BI blog, Patrick Leblanc (@GuyInACube) shares the Power BI November 2024 Feature Summary
- Also on the Power BI blog, Kim Manis (@kimmanis) shares an Important update to Microsoft Power BI pricing
- Also on the Power BI blog, Michal Foster Heldy (@Michal36040600) writes Introducing Copilot in Power BI Mobile Apps (Preview)
- Nirupama Srinivasan (@MSPowerBI) presents Paginated Reports PM Nirupama Srinivasan updates Paginated Report Bear on the latest features