web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Migrate 1.7TB of data ...

Finance | Project Operations, Human Resources, ...

Unanswered

Migrate 1.7TB of data to Microsoft Fabric and setup real time connectivity

(0) Share

Report

Report

Posted on by Community member

I am trying to connect and migrate data from Dynamic FO to Microsoft Fabric. I have tried via dataverse dual-write enablement and then connected dataverse with Fabric via synapse link. issue is dataverse does not allow 500,000 rows of data. so i am cannot move large tables due to that. I am struggling to find the solution/approach that help achieve following:
- Migrate historical data to Fabric - and do reporting and AI use cases there
- Make data modeling/data mapping simple (data verse helps with that, that is choose dataverse)
- Integrate Fabric with dymaic to capture real time chnages in the data
- Digitize workflows via powerapps on top of dataverse.

Please advise me if i am thinking wrong and what should i do?

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Syed,

You can use the Synapse link for F&O. You can read more about it here: Choose finance and operations data in Azure Synapse Link for Dataverse - Power Apps | Microsoft Learn

Note that this link will be near real time as it is an async process.

Was this reply helpful? Yes No
Hana Xue Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,
The documentation mentions that if you must have more than 500,000 rows in the run when using initial sync, it is recommended that you migrate the data into the Finance and Operations apps and the Dataverse respectively and skip the initial sync.
dynamics-365-unified-operations-public/articles/fin-ops-core/dev-itpro/data-entities/dual-write/initial-sync-guidance.md at main · MicrosoftDocs/dynamics-365-unified-operations-public · GitHub

Best Regards,
Hana

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Giorgio Bonacorsi 663

#2

André Arnaud de Cal... 439 Super User 2026 Season 1

#3

Syed Haris Shah 337 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans