Hi,
At my company, we have been using the 'Export to Datalake' add-on to access D365 F&O data by exporting it to an Azure Data Lake. As it is going to be deprecated, we started migrating to Synapse Link.
We created a PowerApp environment for D365 UAT and enabled SQL row version tracking. Then, a Synapse Link was created from that PowerApp environment by choosing a Data Lake, Synapse workspace, and Spark pool. The Link seems to have been created successfully. However, we've tried exporting two F&O tables, and it has been three days now, but the status is still 'Initial sync is in progress.'
I am not sure where it has gone wrong. I can see the tables under the Synapse Lake Database, but when I query those tables, they are empty.
Would appreciate any guidance.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 846 Super User 2025 Season 2
CA Neeraj Kumar 838
Sohaib Cheema 818 User Group Leader