cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors