D365 FO Data Entity and Fabric

Hi MKBoopathy ,

Thanks for sharing the background and your specific requirements.

Based on what you described, the Link to Fabric feature actually aligns well with your goals. It allows you to virtualize D365 FO data entities directly into a Fabric lakehouse without physically copying the data.

Since your Power BI reports are already using those entities, this setup ensures continuity. It also avoids load on BYOD and supports integration with services like Logic Apps and Power Automate by exposing the tables through the lakehouse.

That said, if you still prefer to use the copy activity to bring the data into Fabric, the earlier steps still apply -

i. removing and re-adding the source in your pipeline typically refreshes metadata, and ii.regenerating the mappings in D365 FO ensures the newly added fields are exposed.

iii. For historical loads, segmenting by date ranges helps avoid failures and long runtimes.

Hope this helps. Please reach out for further assistance.

Thank you.