Forum Discussion
Share and use datasets from different tenants
Hi Anonymous ,
In desktop, you can connect to the same dataflow with different tenant accounts.
Dataflows are NOT linked to the currently signed in user. The connection is authenticated, not the current user. The “Sign In” button must be selected, and authentication completed to connect to a Power BI dataflow.
The connection information for the dataflow is cached with Power BI Desktop, and subsequent connections to dataflows will not require the user to sign in.
The connection information for the dataflow is cached with Power BI Desktop, and subsequent connections to dataflows will not require the user to sign in. The same authentication credentials will be used.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community ChampionAnonymous Are we talking different tenants? Tenant in Power BI is the same as an Office 365 tenant basically. It is a logical construct for security. Things don't pass between tenants. You can't even migrate the email from one Office 365 tenant to another without extracting all of the data and then importing all of the data.
What you have there is for building multi-tenant (read customers) reporting. So think an ISV building a cloud app has multiple "tenants" or customers. However, it's all in a single Azure "tenant", the one the ISV owns.
Right?
Greg_Deckler I see... I thought that through APIs you could somehow bypass the tenant boundaries.
The scenario I have is a customer (we are not their CSP/ISV) with two tenants. They want to unify their datasets and be able to share the same reports based on both datasets.
What I was thinking then is to automate exporting the data from Tenant 1 with a scheduled job, saving the file locally, and feed Tenant 2's Power BI with that file as a source, merge the data in one table, build a report in Tenant 2, and share the report with Tenant 1.
This would give data redundancy, but I guess it would get the job done... Suggestions?
- Greg_Deckler
Anonymous
- LOL... 😄
V-lianl-msftCommunity Support
Hi Anonymous ,
In desktop, you can connect to the same dataflow with different tenant accounts.
Dataflows are NOT linked to the currently signed in user. The connection is authenticated, not the current user. The “Sign In” button must be selected, and authentication completed to connect to a Power BI dataflow.
The connection information for the dataflow is cached with Power BI Desktop, and subsequent connections to dataflows will not require the user to sign in.
The connection information for the dataflow is cached with Power BI Desktop, and subsequent connections to dataflows will not require the user to sign in. The same authentication credentials will be used.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.