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:
This is no longer correct. Please see below answer by Maignan or
Using DirectQuery for datasets and Azure Analysis Services (preview) - Power BI | Microsoft DocsCan you provide the steps in importing the data for multiple datasets from Power BI Service to Power BI Desktop? I already tried this but was limited to only one dataset. Thanks!
This is possible now by using composite models.
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
Hi DanUlrich,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank- If you download the Power BI add-on for MSExcel, you can connect to multiple datasets and combine the data from them. Not in the same pivot table, but using lookups might work for you
