Skip to main content

Notifications

Announcements

No record found.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans