cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alienvolm
Helper IV
Helper IV

Share and use datasets from different tenants

Hello, 

 

I was wondering if it's possible to share (and use) datasets from different tenants to produce unified reports. Maybe with Power BI Premium? 

 

Do you have any article of reference? 

 

Thanks in advance! 

1 ACCEPTED SOLUTION

Hi @Alienvolm ,

 

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.

View solution in original post

8 REPLIES 8
Greg_Deckler
Super User
Super User

@Alienvolm Not to my knowledge. You can share between workspaces but not tenants. See Usage Models:

https://community.powerbi.com/t5/Community-Blog/Power-BI-Usage-Models-in-Pictures/ba-p/1342820


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

@Greg_Deckler I found this page where there is an explanation of Power BI Embedded for a multi-tenant situation: https://docs.microsoft.com/en-us/power-bi/developer/embedded/embed-multi-tenancy 

 

However, I still have no clue on how to practically implement it or to test it... 😐 

It's the first time I hear of it, but I'm not a developer. 

@Alienvolm 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?


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

@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? 

@Alienvolm 


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

LOL... 😄

Hi @Alienvolm ,

 

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.

View solution in original post

Hi Liang, can you elaborate more on this approach?  It seems confusing to me.  

So in order for a PBI dataset/report in Tenant2 to use dataflow in Tenant1, will I need to:

- sign in Desktop as Tenant1 user, connect to dataflow in Tenant1

- then save and send the file to a user in Tenant2, or re-sign-in Desktop as Tenant2 user

- publish Desktop to Tenant2

Is this the correct workflow? Will the cloud refresh in Tenant2 work? Do we need to provide Tenant1 user credential (for the dataflow source) in the cloud refresh settings in Tenant2 dataset?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.