Forum Discussion

Lora_0121's avatar
Lora_0121
Advocate I
1 year ago
Solved

How to Share Data Between Workspaces

Hello, 

I want to use the sales data from Workspace A in Workspace B so that I don't have to duplicate the same data.

Is this possible?

If I create a report in Workspace B using the sales data published in Workspace A, will the report be published in Workspace A or Workspace B?

Need Help

6 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    yes, you can connect to other semantic models, either from the same workspace or from other workspaces.

     

    NOTE: Your report users need to have access to (and have "installed") both apps  (or both workspaces if you don't use apps) !

    • Lora_0121's avatar
      Lora_0121
      Advocate I
      1 year ago

      I cannot see the sharing option in the Admin Portal. Is there a higher-level administrator?

      • lbendlin's avatar
        lbendlin
        Super User
        1 year ago

        This setting is done in each workspace/semantic model, not on capacity or tenant level. Allow "build access".

  • SaiTejaTalasila's avatar
    SaiTejaTalasila
    Super User
    1 year ago

    Hi Lora_0121 ,

     

    You can connect to XMLA analysis services endpoint using analysis services connector from the new report to the existic semantic model and pull the data.

     

    I hope it will be helpful.

     

    Thanks,

    Sai Teja 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Lora_0121 ,

    Based on the testing, it is possible to create a report in workspace test12-9 using the dataset 9-24test export color published in workspace test9-18.

    Creating a new report. Select pick a published semantic model from test9-18 workspace.

     

    Then, save the report, select the workspace and enter the report name.

    You can also view the following documents to learn more information.

    Introduction to semantic models across workspaces - Power BI | Microsoft Learn

    Create reports based on semantic models from different workspaces - Power BI | Microsoft Learn

     

    Best Regards,

    Wisdom Wu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.