Permission to turn on Interactive Authoring in Azure Synapse Analytics

@Jonathan Kelly

Thanks for sharing the details of your issue.

The error you're encountering - "AuthorizationFailed" with the message about lacking permission for Microsoft.Synapse/workspaces/integrationruntimes/enableInteractiveQuery/action indicates that your user account doesn't currently have the required Azure RBAC (Role-Based Access Control) permissions at the correct scope, even if you have "Admin" access in the Synapse Studio interface.

To resolve this issue, you need to grant the managed identity the necessary permissions to access the resource.

If the Synapse managed identity doesn't have permission to perform actions like pause or resume, you might encounter the error mentioned below. To fix this, assign the contributor role to the workspace's managed identity as follows:

Go to the IAM section of the Synapse workspace, click 'Add,' and then select 'Add role assignment' as shown below:

Go to Privileged Administrator Roles and select the Contributor role, as shown below:

Click on next select managed identity as shown below:

Once the role is assigned successfully, the web activity will run without any errors, and actions like pause or resume will work correctly using the REST API, as shown below:

If the issue still persists,

The error might not be related to the user but to the application. Kindly look for application/SPN name with client ID: 'xxxxxxx-xxxxx-xxxxxx-xxxxxx'.

Navigate to the subscription > Choose the subscription > Add Role assignment > Reader > assign to the application SPN:

I hope this information helps. Please do let us know if you have any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Thank you.