Power BI Weekly
Issue #226 - 26th September 2023
A bit of a light edition this week - no announcements other than the On-premises data gateway September 2023 release. So, onto the community articles. First of all, Alberto Ferrari has weighed up the number of ways you can Find products without sales by using DAX, Chris Webb has discussed how you can Keep Your Existing Power BI Data And Add New Data To It Using Fabric, offering a more robust solution to a previous post he wrote describing how to achieve incremental refresh without a backing relational store. And finally, Rick de Groot has written in detail about Understanding Recursion in Power Query using the Tower Of Hanoi puzzle as a fun demonstration.
🛠️ Data Prep
- Chris Webb (@cwebb_bi) explains how to Keep Your Existing Power BI Data And Add New Data To It Using Fabric
- On the Perficient blog, Dhananjay Gokhale (@Perficient) describes Power BI & Excel Connectivity: Scenarios Which Can Break Dashboard
- Reid Havens (@HavensBI) talks about the Pareto Principle for Power BI: Few Tricks, Big Wins (with Denis Selimovic)
- Rick de Groot (@Rickmaurinus) describes Understanding Recursion in Power Query: Tower Of Hanoi and writes about Wildcards in Power Query M
🧩 Data Modeling
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) discusses Finding products without sales by using DAX
- Miguel Félix covers Qual o registo seguinte? [Portuguese]
- Chandeep Chhabra (@chandeep2786) describes How to Fix Incorrect Totals in Power BI
- On the phData blog, Dave Rogers (@phdatainc) describes How to Create a Dynamic Date Axis in Power BI
📊 Report Authoring and Interactivity
- Bas Dohmen (@HowToPowerBI) discusses The art of subtle animation in Power BI
- Fowmy Abdulmuttalib (@ExcelFort) describes One Chart – Two Insights: Power BI Line Chart Trick with Error Bars
- Erik Svensen (@donsvensen) describes how to Power BI – Set a background to a URL image without a theme file
- Daniel Marsh-Patrick (@the_d_mp) announces Deneb 1.6 Ready for Beta Testing
🚀 Deployment, Security and Operations
- On the Power BI blog, Nikki Waghani (@NikkiWaghani) announces On-premises data gateway September 2023 release
- Ted Pattison (@TedPattison) presents Power BI Dev Camp Session 35 - Power BI Embedding Best Practices with the Power BI JavaScript API
- Tom Martens (@tommartens68) writes A song to the unnoticed heroes of every successful Power BI solution - the on-premises data gateway, the vnet gateway, and the sharable cloud connection
🌐 General
- The Knee-Deep in Tech team (@KneeDeepinTech) present Podcast episode 237