Power BI Weekly

Issue #196 - 28th February 2023

An announcement that came in yesterday, which I can't quite tell whether it comes as a surprise, is that Streaming Dataflows are being retired as of mid-March (2023). I hope those using Streaming Dataflows got a bit more notice about their retirement than the couple of weeks of notice given in the blog! Anyway, the Power BI team has pointed people towards the Azure Stream Analytics No-code editor as a migration path which now offers a superset of the Streaming Dataflows capabilities. Learn more about how you can then integrate with Power BI on that blog. The other announcement this week is the On-premises data gateway February release. Not really any updates other than Power BI Desktop version alignment, but there is a notice for those using Power BI Dataflows which connect to on-prem gateway data sources; if your gateway version is older than April 2021, your connection might fail. So remember to update!

Elsewhere this week, Ted Pattison has presented Dev Camp Session 30 - Building Multi language Reports for Power BI in 2023, showing off a useful external tool to achieve this in an easier manner. Phil Seamark has described how to Speed up Distinct Count calculations in Power BI using Aggregations, Denis Selimovic has described How to block other people from overriding your dataset in Power BI (and why you might not want to do that), and Kurt Buhler has written a brilliant article (as ever) titled “It Depends” - Power BI Best Practices & Optimizations, describing the differences between "best practices" and "optimizations", and showing the experimental approach required to properly diagnose and solve issues.