Power BI Weekly

Issue #223 - 5th September 2023

It's an abnormally short edition this week - there are almost as many links in this editorial than there are in the rest of the newsletter! Maybe everyone's still on vacation? Who knows. Anyway, the Power BI Fabric team has still given us a couple of articles to sink our teeth into. The first of which is the subtle but huge announcement around the all new Shareable cloud connections, which allow you to support multiple connections to the same data source and share connections with other users, which in turn lower the overhead of maintaining data connections and credentials. In real terms, this means you can now avoid the "take over and reenter credentials" shenanigans when your colleague is on holiday, and you can also configure different credentials to the same cloud data source (instead of being tied to a single set that must be reused across all datasets that connect to that data source). Effectively, cloud data sources now work very much like enterprise data gateway data sources. Woohoo!

The other official article this week is around some Best Practices to prevent GetGroupsAsAdmin API timeout, describing the patterns related to $expand and $filter to follow to try to avoid the queries timing out. Sticking to the API theme - Gerhard Brueckl has show how to Query the Power BI REST API using Fabric Spark SQL, which could be very useful if you have analytical requirements over your Power BI metadata. Finally, Teo Lachev has described Yet Another Currency Conversion Pattern to dynamically apply conversions to your monetary measures.