Share via

I cannot access synapse workspace in Azure. error code

Xhevahir Mehalla 40 Reputation points
2024-05-09T15:19:23.46+00:00

Failed to load

Failed to load role assignments due to forbidden issue, error code 403. Refresh or troubleshoot the issue.

Please can someone help.

I am the owner of the subscription.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,446 questions
0 comments
Accepted answer
  1. Clint Grove 76 Reputation points Microsoft Employee
    2024-05-13T15:30:48.8833333+00:00

    When you create a Synapse workspace its important to either add yourself and other AD accounts using Azure CLI task. See my github page for this. https://github.com/clintgrove/azure-synapse-bicep-v2

    You can also see what I have done in this screenshot

    Basically, you are creating the Synapse workspace with a service principal, but you are no where to be featured, so you have to add yourself. In the arguments on line 48 you will see a GUID, that is my object ID in Entra ID

    User's image

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. BhargavaGunnam-MSFT 27,156 Reputation points Microsoft Employee
    2024-05-09T16:35:57.3033333+00:00

    Hello Xhevahir Mehalla,

    Welcome to the Microsoft Q&A forum.

    The error code 403 is related to an authentication error. It's possible you don't have access

    Check if you can grant yourself Synapse Admin or Synapse Contributor role under Synapse Studio > Access Control tab.

    For reference: https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-understand-what-role-you-need#tasks-and-required-roles https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-synapse-rbac-roles

    A similar thread was discussed here: https://learn.microsoft.com/en-us/answers/questions/732285/synapse-studio-403-unauthorised-even-with-owner-pe

    If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.

    1 person found this answer helpful.