Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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?   ...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago
    LOL... 😄
    • V-lianl-msft's avatar
      V-lianl-msft
      Community Support
      5 years ago

      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.

      • chaz2jerry's avatar
        chaz2jerry
        Advocate IV
        5 years ago

        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?