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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
marcritchie
Frequent Visitor

Excel Connection to Dataset can only be updated by Contributor on Workspace or above

Hi there,

 

I'm having real problems with a use case I have. I have an excel workbook with multiple pivot tables using a connection to a Power BI dataset. I don't want the users of this workbook to have access to the workspace so give them direct access using Manage Permissions on the dataset and giving them build access there.

 

However the only way I can find that lets them refresh the Excel workbook is having them as a Contributor role on the workspace as a minimum. Without that they can't refresh and also RLS doesn't apply. This opens up the possibility that they can make changes in the workspace when all I need them to be able to do is refresh the Excel workbook that is already set up for them in the format required.

 

Am I missing something or is this expected - if it is expected then a Power BI dataset is almost useless when used with Excel if you want to have any kind of security over the solution.

 

Thanks,

Marc

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.