Forum Discussion
Can a Report use Multiple Datasets?
Hi DanUlrich
In Power Bi service, you can create multi reports by the same dataset, However you cannot create one report by using different dataset. One way to work around, creating dashboard could combine different visuals from different reports. Also you can connect to all the data sources of different datasets and import the data by Power BI desktop, then you can use all the data.
Regards,
Frank
Hi DanUlrich
In Power Bi service, you can create multi reports by the same dataset, However you cannot create one report by using different dataset. One way to work around, creating dashboard could combine different visuals from different reports. Also you can connect to all the data sources of different datasets and import the data by Power BI desktop, then you can use all the data.
Regards,
Frank
Hi folkfs,
DUe to a new Direct Query features in preview now you CAN now use two Power BI service Dataset in the same report, when creating a local model. There are limitations, but it works. More info there
Did something change recently? I was able to do this until today.
I keep getting this error: Details: "We could not connect to the Analysis Services server because the connection timed out or the server name is incorrect."
my existing reports which I have multiple data sets still work. But I can not combine new ones anymore.
I found the answer, its a known issue:
