Importing one Power BI to multiple other PBIX

[Luklaman]

I have four standalone Business Units (BU) who each have multiple sites running various ERP's systems (say ten per BU). They each have their own PBI Desktop and published reports, owned and managed locally. Each has a 'master' query within their dataset, and these reports automatically refresh and published at 1am.

I want to create a fifth report for Corporate, which links into the dataset's from each BU, and imports them as query’s, which I can then append into one table, and refresh at 2am.

Is this possible? I'd hope so considering the similarities with MS Access.

[v-easonf-msft]

Hi , @Luklaman 

In any case, you can only connect one dataset on the service, so it is recommended to create a fifth pbix that integrating the remaining four queries into one query, and then publish to service and configure the credentials and  refresh settings for each data source.

Best Regards,
Community Support Team _ Eason