Power BI Weekly
Issue #135 - 7th December 2021
A handful of updates this week, including the new v4 Power BI APIs .NET SDK, with the main change being the addition of new, more specific classes to more accurately represent the object type returned when calling certain APIs. We've also been given a Power BI Streaming Dataflows November Update where the single (but significant) announcement is that arrays are now supported - great for unrolling batched data received from source. The final update from this week is that the On-premises data gateway November 2021 update is now available, with the only update being its compatibility with the November version of Power BI Desktop.
Elsewhere this week, Jeroen ter Heerdt has written about an often confusing behaviour of the underlying Analysis Services engine, writing about The capitalization (uppercase / lowercase) of my text data changed in Power BI! Why?, and Ruth Pozuelo Martinez has started a 25 Days of DAX Fridays! Challenge with a different business problem to solve every day up to Christmas day. You'll have to catch-up though - it's already the 7th (if you hadn't already figured that out!)
🛠️ Data Prep
- On the Power BI blog, Krrish Dholakia provides a Power BI Streaming Dataflows November Update
- Rui Romano (@RuiRomano) blogs about Power BI Dataflows & Object Level Security (table level)
- On the dev.to blog, Marvin D. Tensuan discusses Power BI's Power Query (M) for Python Programmers
- Gašper Kamenšek (@ExcelUnplugged) writes about AI in Excel – Part 2 – Column From Examples
- On myOnlineTraininghub, Mynda Treacy (@OnlineTrainingH) covers Power Query Keyboard Shortcuts to Save Time
- Parker Stevens (@PowerBIElite) covers Making sure your Power BI web data source refreshes online (RelativePath, Query, BrowserContents)
- On the Enterprise DNA blog, Gaelim Holland describes Power BI With Python Scripting To Create Date Tables
🧩 Data Modeling
- Alberto Ferrari (@FerrariAlberto) presents Answering questions: running total and last dates within selection – Unplugged #38, and shares a couple of tutorials MOD, QUOTIENT – DAX Guide and CONVERT, INT, CURRENCY – DAX Guide
- Jeroen ter Heerdt (@jeroenterheerdt) discusses The capitalization (uppercase / lowercase) of my text data changed in Power BI! Why?
- On the Purple Frog Systems blog, Joe Billingham walks through Making the DAX Engine Work for You
- Chandeep Chhabra (@chandeep2786) covers Optimizing IF using MAX and MIN Functions
- On the MSSQLTips site, Kenneth A. Omorodion describes how to Dynamically Compute Different Time Duration in Power BI Using DAX
- Ruth Pozuelo Martinez (@CurbalEN) introduces the 25 Days of DAX Fridays! Challenge | Are you in?
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes about the CALCULATE Function – How It Can Affect Your Calculations On Power BI
- Reid Havens (@HavensBI) talks about Tabular Editor 3: Present & Future with Daniel Otykier
📊 Report Authoring and Interactivity
- On the RADACAD blog, Reza Rad (@Rad_Reza) talks about Power BI From and To Date Filtering with One Slicer
- Greg Philps describes Using Deneb For Flexible Custom Visuals In Power BI
- Bas Dohmen (@HowToPowerBI) describes a KPI car hover effect in Power BI
- Patrick Leblanc (@GuyInACube) describes how to Use Page Navigator in Power BI
- On the Learning Science YouTube channel, Learning Science talks about the Bookmark Navigator in Power BI
- Dhruvin Shah (@DhruvinShah16) talks about the New Format Pane in Power BI Desktop
- Rajat Talwar discusses All you should know about Power BI Goals and AI
- Brian Julius provides a Sort Legend Tutorial And Review
🚀 Deployment, Security and Operations
- On the Power BI blog, Noam Raveh announces the Power BI APIs .NET SDK v4
- Also on the Power BI blog, Miquella de Boer announces that the On-premises data gateway November 2021 update is now available
- Chris Webb (@cwebb_bi) discusses Troubleshooting Power BI Timeouts, Part 1: The Two/Five Hour Import Refresh Limit
- Adam Saxton (@GuyInACube) describes how to Call any Power BI REST API with PowerShell
- On the Blue Granite blog, Elayne Jones describes Digging into Power BI Deployment Pipelines
- Philipp Lenz (@lenz_philipp) writes about Continuous Deployment of Azure Analysis Services
- Reid Havens (@HavensBI) covers Migration Tips and tricks when moving from AAS to PPU w/ Gilbert Quevauvilliers and Havens Consulting discusses The Data God Guide to Power BI Gen2 with Chris Wagner - Kratos BI
- On LaDataWeb, Ignacio Barrau (@ignacho_07) writes Librería de Python para Power Bi Rest API [Spanish]
🌐 General
- Nicky van Vroenhoven (@NickyvV) writes about My Favorite Power BI Desktop November Updates
- Adam Saxton and Patrick Leblanc (@GuyInACube) present Power BI tips from the Pros – LIVE (Dec 4, 2021)
- On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) talks about Trolling the Power BI Ideas Site