How to combine multiple datasets into a new dataset?

Question

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?

David Browne - Microsoft · Answer

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.

How to combine multiple datasets into a new dataset?

1 Answers