Reputation: 9644
I have 2 power bi datasets deployed into the workspace.
I want to create a new report that makes use of both the datasets. In a new report when I choose 1 of the datasets, then the transform query button gets grayed out. I'm not sure how to choose the 2nd dataset. Does power bi have the ability to choose multiple datasets for a new report?
Upvotes: 0
Views: 4777
Reputation: 88851
The ability to query across multiple Datasets is currently in preview.
Using DirectQuery for Power BI datasets and Analysis Services
Or you can build a third dataset that imports some of the same source data as the other two.
Upvotes: 1