Unable to create Synapse through CSP using CLI or Portal

Rafi Trad 36 Reputation points
2022-11-04T15:02:47.84+00:00

I am a CSP partner and I am trying to create a Synapse workspace on a client's tenancy.

I tried creating the workspace in Azure Portal and Azure CLI cloud shell, and in both cases, I am getting this error:
{
"status": "Failed",
"error": {
"code": "WorkspaceCreateOrUpdateApiFailed",
"message": "An error has occurred. Please contact Microsoft support with correlation ID: ???",
"details": [
{
"code": "WorkspaceAdminInfoMissing",
"message": "Workspace AAD admin information is missing. If you are a CSP partner, please provide workspace admin info in workspace request payload."
}]}}

Microsoft.Synapse is registered in the subscription, as well as Microsoft.SQL.
What should I do to proceed?

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.
2,606 questions
Microsoft Partner Center API
Microsoft Partner Center API
Microsoft Partner Center: A Microsoft website for partners that provides access to product support, a partner community, and other partner services.API: A software intermediary that allows two applications to interact with each other.
257 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 7,406 Reputation points Microsoft Employee
    2022-11-06T18:32:52.697+00:00

    Hello @Rafi Trad ,

    Welcome to the MS Q&A platform.

    It seems like a permission issue.

    To create an Azure Synapse workspace, a user must have Azure Contributor role and User Access Administrator permissions, or the Owner role in the subscription.

    As per the error message, you will need to work with your cloud solution provider to get the correct level of access. Please look into this document explained about how to manage subscriptions and resources under the Azure plan

    I hope this helps.


  2. Rafi Trad 36 Reputation points
    2022-11-24T15:42:43.85+00:00

    The only solution we found was to use REST API calls to create Synapse resources on CSP tenancies, while supplying a correct value in:

    "cspWorkspaceAdminProperties": {
    "initialWorkspaceAdminObjectId": "X-X-X-X"

    Here is the article that describes how to do that: https://learn.microsoft.com/en-us/rest/api/synapse/workspaces/create-or-update?tabs=HTTP&tryIt=true&source=docs

    It is a deal breaker for our use-case, and we are thinking to stop using Synapse altogether, especially that we cannot automate creating Synapse easily when we have to go through REST API calls! Way too unnecessary.

    Thank you.

    No comments