Consolidating Multi Tenant Datasets and Dataflows

[THEG72]

Is there any method available to read multiple Power BI datasets from different tenants for consoldation and reporting purposes?

[THEG72 · Accepted solution]

HI @ibarrau
After speaking to a few MVPs and experienced users, Multi tennant models arent available yet.

[THEG72]

I was looking into Purview, there are currently ideas to allow multi-tennant datasets in the view. Be great if this can apply to data flows too..Premium costs put this out of the budget unfortunately so i dont think end points is a solution.

https://feedback.azure.com/forums/932437-azure-purview/suggestions/42404434-support-power-bi-scannin...

I agree there should be a way but currently there isnt...Please help vote up the ideas

[ibarrau]

Hi. That's tricky. I'm not sure. The only way I can think that might work is with a dataset in premium capacity. You can try getting its data with Azure Analysis Service connector and the xmla endpoint with one account. Then publish to another tenant with a different account. I don't think that would work, but that's the only way it might.

Otherwise you might as people with a better understanding of Azure AD. There should be a way to integrate different AD tenants in order to share services.

I hope that helps,