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
mbbozzuto
Helper II
Helper 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
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