Single Direct Query table from multiple reports.

[Devjeet]

Hi,

I wanted to know if there is a quick and efficient way to connect multiple datasets from reports using Direct query into a common dashboard.

Is there an efficient way to achieve something like this.

[v-jingzhang]

Hi @Devjeet 

Do you want to combine tables from multiple reports' datasets into a single table? You can connect to multiple Power BI datasets with DirectQuery. Then use UNION function to join multiple tables. However, this joined table will be in Import mode and it cannot be modified in Power Query Editor. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[amitchandak]

@Devjeet , if they are power bi dataset, you can use direct query to the dataset.

You can create a power bi service dashboard 

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-s...