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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors