Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Ariel_Valdes
New Member

Allow user to see all reports in the organization

Hello,

My organization has a lot of workspaces and reports.

I need to be able to give the CEO access to everything without giving him permission to edit,
and without the need to go to each workspace to give access.

Though if it can be done only with edit permission too, it's ok.

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey @Ariel_Valdes ,

 

unfortunately, someone has to go through all workspaces.

But this someone can be a PowerShell script.

Basically you need these REST API calls

To prevent editing the new user must assigned the Viewer permission (groupUserAccessRight).

 

You have to be aware that the user or the member of the groups needs to have a Pro license when the workspaces are not backed by Premium Per Capacity (P[x] capacities). If the workspaces are backed by Premium Per User capacities, then the user(s) must have a Premium Per User licensc.

Hopefully, this provides you with some ideas on how to tackle your challenge.

 

Regards,

Tom

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

3 REPLIES 3
TomMartens
Super User
Super User

Hey @Ariel_Valdes ,

 

unfortunately, someone has to go through all workspaces.

But this someone can be a PowerShell script.

Basically you need these REST API calls

To prevent editing the new user must assigned the Viewer permission (groupUserAccessRight).

 

You have to be aware that the user or the member of the groups needs to have a Pro license when the workspaces are not backed by Premium Per Capacity (P[x] capacities). If the workspaces are backed by Premium Per User capacities, then the user(s) must have a Premium Per User licensc.

Hopefully, this provides you with some ideas on how to tackle your challenge.

 

Regards,

Tom

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

@TomMartens Thank you for your response, well it is what it is then. 

Greg_Deckler
Super User
Super User

@Ariel_Valdes I don't know of a solution to do that other than perhaps using the Power BI REST API via PowerShell to add the CEO to the Viewers role for each workspace. You should be able to automate that via the REST API to grab all workspaces in the tenant and then add the user to the Viewers role.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors