Power BI Weekly

Issue #257 - 7th May 2024

A few announcements this week: we've been told about live connect for Power BI report integration with OneDrive and SharePoint (Preview) whereby reports stored in OneDrive/SharePoint that have a live connection with a Power BI semantic model can be viewed in-place within OneDrive/SharePoint (previously only supported for Import mode). Over in Fabric land, we've been told about the long awaited Semantic model refresh activity to chain your refreshes more easily in your overall orchestration pipeline, and (while not directly related to Power BI) we've also been told about the new external data sharing functionality: a new way to collaborate across Fabric tenants. You can now connect to Lakehouses, Warehouses, KQL Databases and mirrored databases stored in other orgs' tenants, and then build your own semantic models on top of these data sources!

Aside from announcements this week, Bernat Agulló Roselló has worked some more Calculation Group magic to demonstrate a really cool way to Show the path of the selected point in a scatter chart, Meagan Longoria has described how you can Use a slicer to filter a visual based upon a measure in Power BI, and Marco Russo has shared some Best practices for using KEEPFILTERS in DAX, an often confusing function when apply a custom filter context in DAX measures.