Hi @equerystrian ,
Originally, establish a live connection to a shared dataset in the Power BI service, but there are many considerations and limitations to keep in mind, like:
- left-navigation and modeling are disabled.
- Calculated columns are disabled.
- Power Query Editor is not available
- Could not connect data from multiple sources
But with the previewed feature——using DirectQuery for Power BI datasets and Azure Analysis Services, we could add data from other data sources and do some data modeling ,which I think is very helpful. As the official document mentioned, Report authors who want to combine the data from their enterprise semantic model with other data they own, such as an Excel spreadsheet, or want to personalize or enrich the metadata from their enterprise semantic model, will find this feature especially useful.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.