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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register 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.


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors