Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Answered

Error Setup Azure Synapse Analytics Connection

(0) ShareShare
ReportReport
Posted on by

Receive permission error while creating the connection. I have Storage Blob Data contributor role in my storage account, Synapse Admin role in my Azure Synapse workspace and Admin role in my DCI env, what else am I missing?

Thanks.

DCI2SynapseError.PNG

  • vanlan Profile Picture
    vanlan on at
    RE: Error Setup Azure Synapse Analytics Connection

    Email sent.

  • RE: Error Setup Azure Synapse Analytics Connection

    can you pls email the details to cihelp@microsoft.com; I will send a teams invite to help you thru this.

  • vanlan Profile Picture
    vanlan on at
    RE: Error Setup Azure Synapse Analytics Connection

    Followed the instructions, and create 'Dynamics 365 AI for Customer Insights and Dynamics 365 AI for Customer Insights engagement insights' with Storage Blob Data contributor roles and still getting the same error.

  • vanlan Profile Picture
    vanlan on at
    RE: Error Setup Azure Synapse Analytics Connection

    I'm waiting for someone to create a principal account in Azure Active Directory at the moment.

  • RE: Error Setup Azure Synapse Analytics Connection

    if you still need help and would like to get on a chat session, pls feel free to open a service ticket (http://aka.ms/cisupport) or email cihelp@microsoft.com;

  • RE: Error Setup Azure Synapse Analytics Connection

    no. app id is for the "Dynamics 365 AI for Customer Insights" . this does not change.

  • vanlan Profile Picture
    vanlan on at
    RE: Error Setup Azure Synapse Analytics Connection

    In the doc  it mentions to run below command in order to register the app,  should the app id value be replaced with my DCI environment id?

    '

    New-AzureADServicePrincipal -AppId "0bfc4568-a4ba-4c58-bd3e-5d3e76bd7fff" -DisplayName "Dynamics 365 AI for Customer Insights"

    '

  • vanlan Profile Picture
    vanlan on at
    RE: Error Setup Azure Synapse Analytics Connection

    I don't have role permission for my D365 in storage account resource yet, let me go setup one and provide my update later, thanks!

  • Verified answer
    RE: Error Setup Azure Synapse Analytics Connection

    On the Azure Synapse workspace, the service principal for audience insights needs Synapse Administrator role assigned. For more information, see How to set up access control for your Synapse workspace. docs.microsoft.com/.../how-to-set-up-access-control

    The info for the service principal for audience insights is here: docs.microsoft.com/.../connect-service-principal

  • Suggested answer
    RE: Error Setup Azure Synapse Analytics Connection

    also, adding the required permissions info here : docs.microsoft.com/.../export-azure-synapse-analytics

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans