Mirror Dynamics 365 Finance SCM Entity Database in Fabric

There are many ways to analyze Dynamics 365 Finance and Supply Chain data in Fabric. One way is to replicate the Entity Export database. Then load it into a Lake House and combine it with additional data for reporting. Here is a video that shows the complete process from scratch:

Considerations

Exporting entities in Dynamics 365 Finance and Supply Chain to your own Azure SQL DB has been around for a long time. There are some considerations and limitations when using your BYOD (Bring Your Own Database) feature with Fabric:

• Sizing: 100+ DTUs are required. Free and small Basic versions are not supported.
• Networking: Public Endpoint and allow Azure Services
• Security: System Assigned Managed Identity ON
• Table: Column store tables are not supported
• Table: Primary Index required