Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,183 questions
Issue with Synapse Linked Service and Storage Blob Data Contributor Role
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 34%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENL%3C/text%3E%3C/svg%3E)
Nguyen Luong
0
Reputation points
Hi,
I’m encountering an issue when trying to open the Synapse Linked Service that was automatically created by Azure Data Lake Storage. The error message I’m receiving is:
“Please check permission on ... to make sure you have at least 'Storage Blob Data Contributor' role for the storage account '...'. If your access was recently granted, please refresh your credentials.”
Even though I have assigned the Storage Blob Data Contributor role for the storage account and refreshed the credentials several times, the issue persists. (See attached pictures for details.)
Has anyone else faced this problem or know how to resolve it? Any help or insights would be greatly appreciated!
Thank you!
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 64%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Nehruji R 7,811 Reputation points Microsoft Vendor2024-10-17T11:59:32.3033333+00:00 Hello Nguyen Luong,
Greetings! Welcome to Microsoft Q&A Platform.
The error you are encountering indicates that the request being made from your notebook or pipeline is not authorized to perform the operation with the given permission. There could be a few reasons for this:
Double-check the permissions assigned to the service principal being used by your notebook or pipeline. Ensure that it has the necessary permissions.
Synapse notebooks use Azure Active Directory (Azure AD) pass-through to access the ADLS Gen2 accounts. If you are running the notebook directly on the synapse, your account needs Storage Blob Data Contributor to access the ADLS Gen2 account (or folder).
If you are running the notebook via the pipeline, the synapse workspace managed service identity needs Storage Blob Data Contributor to access the ADLS Gen2 account (or folder).
Please check if you provided the storage blob data contributor access
Similar thread for reference - https://learn.microsoft.com/en-us/answers/questions/1489213/storage-blob-data-contributor-role-and-synapse-ana
Troubleshooting docs for reference - https://learn.microsoft.com/en-us/azure/data-factory/connector-troubleshoot-azure-data-lake, https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-data-lake
Hope this information helps! Please let us know if you have any queries to further help with more details.
-
Nguyen Luong 0 Reputation points
2024-10-18T05:43:07.79+00:00 I have already added the Storage Blob Data Contributor permission for the Synapse workspace, but the error still persists. You can check the photo
Sign in to comment
Sign in to answer