Adding SG to all reports in PBI Workspace

[KUMAR_AK]

Hi All 
I have a PBI  workspace with list of reports (around 300 ) in workspace, and i want to add Security group (SG) to all the reports in workspace. i dont want to do it manually (meaning i dont want to go to manage permissions and add user).

1. Is there any automated way to do that ? or any power shell script ?or Rest API to follow ?

Note : While add the user manually using manage permission , i will get the below pop up to add , once i add the user i dont want o send the email  notification to the user (Meaning i want to uncheck the Send email notification) is that possibile while automating the process through powershell or Rest API ?

Can you please help me if there is any powershell script or any automated process to do this ?

Thanks
AK

[saiudthawar22]

HI @KUMAR_AK Did you get the script working. As I have the same scenario where I need to add users to report in powerbI. could you please share me the script if you have it. TIA

[KUMAR_AK]

Hi @v-henryk-mstf 

I dont want to add to workspace , want to add to reports , Okay Here is the ex:
I have a workspace say PBITest - in premium per user and im the admin for the workspace. in that i worksapce i have 200 reports . i have to add SG to all 200 reports in my workspace. 

If i want to add SG im doing manually ie : - opening the report manage permission 
Step 1 : Below Secreenshot .

Step 2 : - Going to Direct access and Add User (Below Screenshot)

Step 3 - Once i add SG i want to uncheck send an email notification (Below ScreenShot)

I want to Add this way for all the 200 reports 
Just checking is there any automated way to do it ?

Thanks
AK

[v-henryk-mstf]

Hi @KUMAR_AK ,

According to your description, you can add groups to workspace via Powershell and set the appropriate role permissions. But it is not possible to share report etc.

POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/users

related blog and similiar solution.

ADDING AZURE AD SECURITY GROUP TO POWER BI WORKSPACE USING POWERSHELL - Ruki's Blog (rukiatu.com)

Solved: Share Power BI Report with PowerShell command - Microsoft Power BI Community

Add users to a Power BI workspace using PowerShell (sqlshack.com)

If the problem is still not resolved, please point it out. Looking forward to your feedback.

Best Regards,
Henry

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

[TomMartens]

Hey @KUMAR_AK ,

I'm wondering why you can't use an app, the intended way of sharing content (reports and dashboards) with users.

I'm not aware of an API that helps to share a report with a group.

Maybe you can consider to create an idea on ideas.powerbi.com

Regards,
Tom