![](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(3.2, 98%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
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.
5,117 questions
![](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(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Greetings & Welcome to Microsoft Q&A forum! Thanks for posting your query!
The error you are encountering, "request not authorized to perform operation," typically indicates that there are insufficient permissions for the operation you're trying to perform on the Azure Cosmos DB analytical store. Here are a few steps you can take to troubleshoot this issue:
Check Role Assignment Scope - Ensure that the "Data Reader" role is assigned at the correct scope. It should be assigned at the level of the Cosmos DB account, not just at the resource group or subscription level. You can verify this in the Azure portal under the "Access control (IAM)" section of your Cosmos DB account.
Managed Identity - If your Synapse workspace is using a managed identity, ensure that the managed identity is enabled and that it has the necessary permissions. You can check this by going to the Synapse workspace settings and looking for the "Identity" section.
Verify Synapse Link Configuration - Make sure that the Synapse Link is properly enabled for your Cosmos DB account and that the necessary configurations are in place.
Access Control - Confirm that the user has been granted the required access to the underlying storage account, as access issues can also stem from the storage account level.
Network Settings - If you are using private endpoints or network isolation, ensure that the network settings allow access to the analytical store.
For more details, please refer to the below links:
https://zcusa.951200.xyz/en-us/azure/cosmos-db/synapse-link-frequently-asked-questions#security
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.