Report Copy and Semantic Model permissions

[dkdirenzo]

Hi, we would like to set up Power BI workspaces as follows:

1. Create a central workspace for reporting team to do analysis and work (only they have access to)

2. Create separate workspace where we will save a copy of a report created using semantic models in workspace #1 - external users/stakeholders will have access to this workspace only.

We now face an issue that users from workspace #2, cannot see data in the copy of the report since they do not have access to the data models in workspace #1. Is there an efficient workaround for this? I know i can add users to read semantic models in the #1 workspace, but this will take a long time to add each individual user and also is ineffecient to maintain.

[v-priyankata]

Hi @dkdirenzo 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-priyankata]

Hi @dkdirenzo 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-priyankata]

Hi @dkdirenzo 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[ibarrau · Accepted solution]

Hi. You can create Power Bi Apps to distribute the reports in a workspace to different audiences. That way you could pick what reporting team should see in one audience 1 of the app and what users/stakeholders should see in audience 2. That will let you keep one single workspace with two different sharings. https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-create-distribute-apps

Keep in mind that you can modify the report at the workspace as many times you want, the power bi app will only change if manually the admin click on "Update App". Otherwise, they won't see visual changes, only data refreshes.

If you really need to keep separate workspaces for some complaince policy or security or whatever. Then you could think workspace #1 as your QA environment and workspace #2 as production or the other way around. My point is. Keep all the effort and development in one workspace. Then you need a place to run a code that would move the report and replace it from one workspace to the other. You can do it in azure devops, azure functions, locallly, etc. Then you need a person with coding skills to create an API request or use a SimplePBI python library like this: https://blog.ladataweb.com.ar/post/697833112208539648/simplepbipython-copiar-pbix-entre-áreas-de

I hope that helps,