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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
AlB
Super User
Super User

Accepting request for report access

Hi all,

I am Admin in a workspace and I am getting requests for access to reports from general users.

I would like somebody else to take care of approving or rejecting these requests. What privileges do they need for this? 

Do they necessarily have to be Admin?

Thanks

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

One more thing, in Workspace settings there is a contact list

aj1973_1-1704325089935.png

I personnaly never tested its fonctionnality. Please test it and let me know.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

8 REPLIES 8
aj1973
Community Champion
Community Champion

Hi @AlB 

Technically End users should not access a Workspace to consume reports. They should be accessing reports in App via AD security groups. 

No they can't be Admins of the workspace, Workspace is meant for collaboration and members to Test, Dev and collaborate with the Admin before going to Production.

If you really have to add them to the Workspace then Viewer Role is good enough. You have to know, only the viewer role doesn't have access to the semantic model but can see reports in the workspace.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Thanks @aj1973 

Sure, viewer role is enough. I wasn't asking about making general users admins but about the person that can approve their access requests.

Right now I am getting all of those request but I do not have the time or the knowledge of the team to determine who can access. I would like somebody else on the team to go over these requests and approve/reject them. What privileges does that person need?

 

 

 

aj1973
Community Champion
Community Champion

Member role is enough. He can add users to the workspace. Careful Only admin can remove users so you don't want to give that role to anyone

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

They can add member but will they receive the access requests? That is what I'm most interested in

Thanks

aj1973
Community Champion
Community Champion

A new user can't see Workspaces if he isn't already in them therefore he can't request access to a workspace he can't see. 

The access request is sent to the owner of the dataset when a report is shared by an Admin, member or contributor of the WS.

In this case you can add the member to the list of contacts of The dataset

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Most likely these people are getting the link to the report from other people in the team, then try to access it and and bumped back, send an an access request.

If I understand correctly the request is always sent to the owner of the dataset? If I am the owner of the dataset, is there a way to delegate that, so another person also gets these requests and can approve them (the person in particular could be granted Admin privileges if necessary, that is not an issue)

Thanks 

aj1973
Community Champion
Community Champion

One more thing, in Workspace settings there is a contact list

aj1973_1-1704325089935.png

I personnaly never tested its fonctionnality. Please test it and let me know.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

aj1973
Community Champion
Community Champion

Correct, if a user clicks on the link shared by another team member the access request will be sent to the Owner of the dataset or by default to the Workspace Admin where the dataset is located. A member with edit permission can Take over the ownership of the dataset and like you said if the person could be granted Admin privileges then why not !

 

All this scenario could be solved by creating a Power BI service account with an outlook service. A service account can replace the Owner of the dataset and the Admin of the workspace in case of absence.

 

Also it is recommended to seperate datasets from its reports in different WS and create Apps where end users can consume reports and dashboards. In Apps there is a Support site where you can add a Sharepoint link for users who want to access a report.

aj1973_0-1704324943542.png

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.