Viewing separate Power BI Organisations Workspaces from One login (Or merging data from Many Org)

[joshuasherlock]

Hi All,

I have 3 Seperate companies with 3 seperate Office 365 organisations. I collect data from each using their respective On-Premise gateways that can be seen by users of their respective companies.

For example:

User at AAA.com can see the data for AAA.com via the AAA.com On-Premises Gateway

User at BBB.com can see the data for BBB.com via the BBB.com On-Premises Gateway

User at CCC.com can see the data for CCC.com via the CCC.com On-Premises Gateway

I'd like for a User (The CEO etc) at AAA.com to be able to see AAA.com, BBB.com and CCC.com also. The data sets don't have to be Merged (this would be nice at a later date), just the workspaces be visible on PowerBI.com. At present this requires 3 seperate logins to view.

Also, Is it possible for On-Premises Gateways to be accessable to more than one organisation? say the on-premises gateway for BBB.com being accessable from the AAA.com PowerBI.com (assuming we would need to provide BBB.com credentials somehow). Can an on-premises gateway feed more that one organisation in PowerBI.com?

Cheers

Josh

[lbendlin · Accepted solution]

This is not so much a gateway issue as it is a tenant/ActiveDirectory issue. Unless AAA,BBB and CCC sit in the same AD tree there isn't really anything you can do in terms of sharing resources or accessing shared resources (for the latter you could work around by giving the CEO a Pro license and guest access to the other tenants/workspaces)