BC2ADLS is not a supported setup, and we would want a way to export data to a Data lake in a sanctioned way. Looking at the implementation done for the other Dynamics products there seems to be a pattern with Synapse Link that would be beneficial for the BC customers as well.
In short:
- Linking or unlinking the environment to Azure Synapse Analytics and/or Azure Data Lake Storage Gen2 in your Azure Subscription.
- Continuous replication of tables to Azure Synapse Analytics and/or Azure Data Lake Storage Gen2 in your Azure Subscription.
- Replication of both standard and custom tables as well as create, update, and delete (CUD) transactions.
Add that Fabric is obviously interesting but we are afraid that the pricing model of this (and Onelake for that matter) would make it an unattractive solution for the segment
-> learn.microsoft.com/en-us/power-apps/maker/data-platform/export-to-data-lake
Comments
You could use the Business Central API for a supported way to extract data. When you connect with dataflow it is actually the API behind the scenes. You could do the same data extraction but better using python in Fabric or else where.regards Jonas Hertzjonas.hertz@bispecialist.se
Category: Reports and Business Intelligence
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team