Power BI Weekly
Issue #279 - 8th October 2024
Only one small announcement this week, which is that there's been an Update to Direct Lake documentation, now expanding on topics such as its use-cases and security considerations. On the community front: we've been gifted a brand new Deneb custom visual from Davide Bacci - this time sharing a brilliant Bar Chart Race Visual. Elsewhere, Daniil Maslyuk has investigated What is Power Query’s time zone? with some interesting findings around Dataflows. Finally, it's great to see that John Kerski has joined Reid Havens to speak about DAX Query View Testing Patterns - a topic that is often overlooked in the BI space but is much-needed, which is why we've spoken about similar topics previously in our articles Testing Power BI Reports with the ExecuteQueries REST API and using SpecFlow and .NET.
🛠️ Data Prep
- On the Power BI blog, Christian Wade (@_christianWade) shares an Update to Direct Lake documentation
- Andrzej Leszkiewicz (@avatorl) shares an M Language Function to Call Open AI API from Power Query
- Ben Gribaudo (@bgribaudo) walks through Exploring Power Query Buffering: How Table.Buffer and List.Buffer Work
- Daniil Maslyuk (@DMaslyuk) writes about What is Power Query’s time zone?
🧩 Data Modeling
- Chris Webb (@cwebb_bi) writes about Different Ways To Create Synonyms In Power BI Copilot
- Chandeep Chhabra (@chandeep2786) talks about DAX Debugging Tricks (Basic to Advanced)
- Reid Havens (@HavensBI) discusses DAX Query View Testing Patterns (with John Kerski)
- Parul Sagar (@parulsagar) writes about Optimizing Performance in DAX Calculations with Variables and Iterator Functions
📊 Report Authoring and Interactivity
- Davide Bacci shares a Deneb Bar Chart Race Visual
- Kurt Buhler (@kurtbuhler) describes how to Fix visuals, replace fields, and mass-format reports in Power BI
- Sunil Mathew (@_sunil_mathew_) describes Dynamic Patterns for SVG Bars and walks through SVG Blink Animation | Highlights/Alerts in Power BI
- Meagan Longoria (@mmarie) delves into Making Legend Order Match Segment Order in a Power BI Stacked Column Chart
- On the Business Intelligist blog, Nikil Prabhakar discusses Search functionality using Apply All
- Reid Havens (@HavensBI) talks about Dark Mode for Power BI Desktop (with Harleen Kuar)
- On the Learning Science YouTube channel, Learning Science (@learn_scitech) talks about How to Enable Dark Mode in Power BI Desktop
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) explains how to Create Sales Analytical Dashboard in Microsoft Power BI Desktop (Sep-2024) DAX - Rahim Zulfiqar Ali
- On the Power BI community blog, Ayşegül Yiğit writes about Regression Analysis in Power BI
🚀 Deployment, Security and Operations
- Kurt Buhler (@kurtbuhler) describes Managing Power BI reports or models using semantic-link-labs and explains how to Recover Power BI reports or models that you can't download
- Romain Casteres (@PulsWeb) writes about Microsoft Fabric - Google BigQuery
- Roland Szirmai (@BILAnalytics) describes How to Achieve Dataflow Incremental Refresh Without Power BI Premium
- Ignacio Barrau (@ignacho_07) covers [Fabric] Integrar repo GitHub con área de trabajo [Spanish]
🌐 General
- On the RADACAD blog, Reza Rad (@RADACAD_COM) talks about Microsoft Certification Exams for Power BI and Fabric