Forum Discussion
Connect To Multiple PowerBi Online Workspace Datasets in one Desktop Report?
Hi there,
I am trying to connect multiple PBI online datasets to my one desktop report.
However, when I go to Get Data> Power BI Datasets, I am only allowed to use one and if I try to add more, I get this message.
Do I have to enable something to get multiple? Or is there a workaround?
Thanks!
2 Replies
There's not something to enable, that is how it works. You could create one dataset for people to connect to that has all of the same data from the other datasets in it depending on the size of your source. There is a new feature called "chaining" you might check out here that might do what you're after though: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models#chaining
Well I need one desktop report that connects to all my online published datasets in different reports. Basically it's a report that compiles data from my other different reports. I don't want to add the sources manually cause I frequently change the datasets and might add a field and if I add it manually I will have to do the same change on this report. Weirdly enough excel allows you to connect to multiple datasets from your online workspace and bring them in as a pivot. I don't know how to translate that methodology in powerbi though.
