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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mbbozzuto
Advocate II
Advocate II

Power BI service Viewer role does not allow Excel read-only access to Dataset

The functionality to connect an Excel Pivot Table to a Power BI service dataset is great but why does the "Viewer" role in a Power BI workspace not allow a Viewer user to connect to a Dataset in Power BI Service for read-only use in Excel?

 

It appears the user must have at least a Contributor role to the Workspace where the Dataset resides in order to connect from Excel thus providing them the ability to post other content to the Workspace or modify the Dataset, which in some cases we want to restrict them from doing so.


Is there a workaround for this?

4 REPLIES 4
v-yangliu-msft
Community Support
Community Support

Hi  @mbbozzuto ,

 

Sorry, there is no corresponding solution, as far as I know, this is the design of Power BI, because according to the design requirements, some workspace only need to be inside the user has the right to view, but not the view of the rights to ensure the security of the data, so there is a Viewer role.

As stated in the official documentation, the Viewer role can only access reports, dashboards, workbooks, etc., but not the corresponding Dataset access, while the Contributor role not only has access to reports, but also has access to the dataset permissions.

Reder to:

Roles in workspaces in Power BI - Power BI | Microsoft Learn

 

You can also submit an idea for it at https://ideas.powerbi.com/forums and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

 

Best Regards,

Liu Yang

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

Hi - thanks for the feedback.  But if I'm understanding you correctly, Viewer level permissions on workspaces support reports and access to the underlying dataset.  We have our datasets separated into their own workspace from reports; users need Viewer roles in both workspaces in order for the reports to function correctly (i.e., even if the user has Viewer role in the workspace for the report, they also need Viewer role in the workspace for the dataset).  They don't need Contributor role in either workspace for the reports to function correctly and read data inside of the Power BI service.  That makes sense, and ideally would work the same for Excel Pivot Table query to just read data; I'll post an idea.

aj1973
Community Champion
Community Champion

Hi @mbbozzuto 

Good thing to separate the report from its Dataset and give permissions to the dataset and the report for users as Viewers, but i would be even better if the end user consumes the report at the App level.

However a user with a Read only permission on the Dataset can not connect to the Dataset and use Excel Pivot. you will need to upgrade the user permission to Build in the Manage Permission 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

Thanks - yes understood that they need the higher permission to Build (or Contributor) but that is what I am trying to avoid - the users should be able to read data without the ability to modify the content.

 

I created an idea for this so please vote for:

 

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=1e4b5c80-ea36-ee11-a81c-0022484ec293

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors