Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Service | Customer Service, Contact Center, Fie... / Azure Synapse Link (Fo...
Service | Customer Service, Contact Center, Fie...
Suggested answer

Azure Synapse Link (For Data Lake now not working)

(0) ShareShare
ReportReport
Posted on by Debbie E 5

we have been linking Dynamics tables to our Data Lake in Azure successfully but it has now stopped working

Power Apps > Data > Azure Synapse Link

All the prerequisites have been met

  • You must be granted an owner role on the storage account.I am an owner in the resource group
  • The Storage Account must be in the same region as the Power App. In this case North Europe, this is correct
  • The Storage Account needs to be StorageV2 General Purpose v2 this is correct
  • It should have hierarchical namespace feature enabled. This is correct
  • To link the Dataverse environment to Azure Data Lake Storage Gen2, you must be a Dataverse administrator. This is correct

However I unlinked and relinked and I get this error

An error occurred. Please try again after some time or reach out to support.

Correlation Id: 5ca588e2-c85b-4ea6-9523-d81dd07e6b86
Session Id: 9672c5ae-fdd8-4104-ac82-c5d9759a2870

I now can't get past this error. When i originally set this up it was before the name change to the Synapse connector. can anyone help me get past this issue and get it working again?

  • Suggested answer
    Marimuthu79 Profile Picture
    Marimuthu79 5 on at
    RE: Azure Synapse Link (For Data Lake now not working)

    Hello,

    I am also facing same issues.  As you mentioned Point # 2- I don't want to enable the all network option. Needs to go with Private IP address  so any alternate option is available without changing the all network options?

  • Naomib Profile Picture
    Naomib 5 on at
    RE: Azure Synapse Link (For Data Lake now not working)

    I'm having the same issues too, hoping that Microsoft support will come up with an answer soon.

  • Matthewjones76 Profile Picture
    Matthewjones76 15 on at
    RE: Azure Synapse Link (For Data Lake now not working)

    No I have a ticket with Ms Support some 5 weeks later - they keep failing to turn up to MS teams calls on the subject....

  • JochB Profile Picture
    JochB 10 on at
    RE: Azure Synapse Link (For Data Lake now not working)

    Hi Matthew, I am having the same issue with all my tables being stuck on 'queued'. Did you manage to solve this?

  • Matthewjones76 Profile Picture
    Matthewjones76 15 on at
    RE: Azure Synapse Link (For Data Lake now not working)

    Did you get theis resolved? - im having  a similar problem - however it was working now all tables are stuck on 'Queued'

  • Debbie E Profile Picture
    Debbie E 5 on at
    RE: Azure Synapse Link (For Data Lake now not working)

    1. please “enable” the “Allow storage account key access” during linking.

    I cant find this option during linking Power Apps to the Data Lake. can you give me more details on this?

    2. Navigate to the “Storage account” and please validate that the networking setting (Allow access from) is selected for “all networks”, If it is not, please switch it to all networks and try to configure the link again.

    This setting is 'All Networks' so should be OK

  • Suggested answer
    Nya Profile Picture
    Nya 29,058 on at
    RE: Azure Synapse Link (For Data Lake now not working)

    Hi,

    Please try to ensure the following two points:

    1. please “enable” the “Allow storage account key access” during linking.
    2. Navigate to the “Storage account” and please validate that the networking setting (Allow access from) is selected for “all networks”, If it is not, please switch it to all networks and try to configure the link again.

    If it still doesn't work, it is recommended to raise a support ticket for further help.

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