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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
sudip2607
Regular Visitor

Workspace Role

Hello beutiful people out there.. Please help me on below one simple question please.

 

Which workspace role is required to modify Spark pool settings for a workspace?
A. Viewer B. Contributor C. Admin D. Member

 

My personal experience is 'Contributor'. I have an user, who has given contributor role to a workspace. He can make changes to the pool and save the setting. 

 

But as per this --> https://learn.microsoft.com/en-us/fabric/data-engineering/workspace-admin-settings, it says user needs to have admin role. Got little confused. Even ChatGPT is saying minimum role required is Admin. Am I doing something wrong? 

1 ACCEPTED SOLUTION
burakkaragoz
Community Champion
Community Champion

Hi @sudip2607 ,

 

Great question — this is one of those areas where behavior and documentation can feel a bit out of sync.

You're right that the official documentation states that modifying Spark pool settings requires Admin role in the workspace. You can find that here:
🔗Microsoft Learn 

However, in practice, Contributor role can sometimes modify Spark pool settings if the workspace permissions are loosely scoped or inherited from broader Fabric-level permissions. This might explain why you were able to make changes with Contributor access.

That said, relying on Contributor for this task isn't guaranteed or recommended. Microsoft enforces role-based access control (RBAC) strictly in some environments, especially in enterprise tenants. So while it might work now, it could break later if policies are tightened.

To be safe and compliant with best practices:

  • Use Admin role for Spark pool configuration.
  • Use Contributor for pipeline, notebook, and dataset development.

Also, here's another helpful doc on Fabric roles and permissions:
🔗 Microsoft Learn 

Let me know if you want to test this behavior in a controlled setup or need help checking your workspace's permission inheritance.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

This response was assisted by AI for translation and formatting purposes.

View solution in original post

13 REPLIES 13
v-prasare
Community Support
Community Support

Hi @sudip2607,

We would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

 

 

 


Thanks,

Prashanth Are

MS Fabric community support
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

I am good now. Thanks. 

Hi @v-prasare 

I would wait for little more to accept response as a Solution. Please accept my apologies 

@sudip2607, is there any progress on above mentioned ask?

 

 

 

Thanks,

Prashanth Are

MS Fabric community support

v-prasare
Community Support
Community Support

Hi @sudip2607 ,

We would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.


@burakkaragoz , @Srisakthi@suparnababu8  thanks for your prompt response.

 

 


Thanks,

Prashanth Are

MS Fabric community support
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

burakkaragoz
Community Champion
Community Champion

Hi @sudip2607 ,

 

Great question — this is one of those areas where behavior and documentation can feel a bit out of sync.

You're right that the official documentation states that modifying Spark pool settings requires Admin role in the workspace. You can find that here:
🔗Microsoft Learn 

However, in practice, Contributor role can sometimes modify Spark pool settings if the workspace permissions are loosely scoped or inherited from broader Fabric-level permissions. This might explain why you were able to make changes with Contributor access.

That said, relying on Contributor for this task isn't guaranteed or recommended. Microsoft enforces role-based access control (RBAC) strictly in some environments, especially in enterprise tenants. So while it might work now, it could break later if policies are tightened.

To be safe and compliant with best practices:

  • Use Admin role for Spark pool configuration.
  • Use Contributor for pipeline, notebook, and dataset development.

Also, here's another helpful doc on Fabric roles and permissions:
🔗 Microsoft Learn 

Let me know if you want to test this behavior in a controlled setup or need help checking your workspace's permission inheritance.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

This response was assisted by AI for translation and formatting purposes.

Hi @burakkaragoz 

 

Thanks for your explanation. I'm convinced but wanted to learn more on this, how the loosly coupled setting works. By the way, your given links are not working for some reason. 

Hi @sudip2607 ,

You're right about the links - sorry about that! Let me explain the "loosely coupled" permissions thing because it's actually pretty interesting how Fabric handles this.

What I meant by "loosely scoped permissions":

In some Fabric environments, workspace permissions can inherit from higher-level settings or get influenced by:

  1. Tenant-level admin rights - If someone has broader Fabric admin permissions at the tenant level, those can sometimes override workspace-level restrictions
  2. Capacity admin permissions - Users with capacity admin rights might be able to modify Spark settings even with Contributor workspace role
  3. Legacy Power BI admin inheritance - Since Fabric evolved from Power BI, some permission behaviors carry over in unexpected ways

Here's what's probably happening in your case: Your Contributor user likely has one of these broader permissions without you realizing it. Check if they have:

  • Any Fabric admin roles at the tenant level
  • Capacity admin access on the capacity your workspace uses
  • Power BI admin permissions that are carrying over

To test this properly: Create a test user with ONLY Contributor workspace access (no other admin rights anywhere) and see if they can still modify Spark settings. My guess is they won't be able to.

The documentation is correct about needing Admin role - but Fabric's permission inheritance can create these edge cases where it seems like Contributor works.

Does your Contributor user have any other admin rights you can think of?

Srisakthi
Super User
Super User

Hi @sudip2607 ,

 

A User with Contributor role cannot update spark pool settings. But can modify spark porperties in environment.

 

Regards,

Srisakthi

Hi @Srisakthi 

I had the same understanding but surprisingly have checked and experienced that with the Contributor role user can update spark pool settings. Thanks for your response by the way. 

suparnababu8
Super User
Super User

Hello @sudip2607 

 

Which workspace role is required to modify Spark pool settings for a workspace?

Answer : Admin

 

I replicated your scenario by granting Contributor access to the workspace. 

suparnababu8_0-1751879215521.png

Later, I opened Contributor role workspace and went to edit and clicked on edit icon.

suparnababu8_1-1751879318746.png

I increased the number of nodes to 16.

suparnababu8_2-1751879350776.png

then when I clicked on save. it show the below

suparnababu8_3-1751879432655.png

Now again If i click on Save, I got a notification 'Spark settings update failed'

suparnababu8_4-1751879466996.png

 

The complete error mentioned in below image.

suparnababu8_5-1751879551372.png

 

 

So, MS documentation is correct. Hope you are clear now.

 

 

Thank you!

 

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

 

 

 

 

 

I checked again, and now I can't do it. You're right to showcase the replicated scenario result.

 

However, I feel @burakkaragoz explained why I got successful last time. Hope you wouldn't mind accepting that response as a solution. Thanks for your time and assistance, much appreciated. 

Hi @suparnababu8 

Thanks for your detailed steps. Surprisingly when I clicked on 'Save' button after changing the node size as 'Contributor', that got saved. Let me recreate the scenario, this time would definitely attach screenshot. 

Helpful resources

Announcements
December Fabric Update Carousel

Fabric Monthly Update - December 2025

Check out the December 2025 Fabric Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.