Small and medium business | Business Central, N...

Export data from BC

(6) Share

Report

Posted on by AH-31052106-0

249

Hello,

Is it possible to export data from BC to a sql server somewhere on premise or cloud?

Thanks!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (1)

Report

Yes, you can import data into Fabric OneLake and create a semantic model based on your requirements.

https://learn.microsoft.com/en-ca/dynamics365/business-central/admin-fabric

https://github.com/Bertverbeek4PS/bc2adls

If this helped you, please check the box Does this answer your question?

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,672 Moderator on at

Like (1)

Report

Yes, there are several options. It depends a bit on why you want this.

For Power BI and most other integrations you can use or create APIs.

You can also create an app that uses XMLPorts or other objects to export or import data in several formats: variable text, fixed text, xml, json,...

You can create a database export (bacpac) and restore it locally.

Microsoft Fabric can also use the APIs to fetch data from BC.

Was this reply helpful? Yes No
RaulBogajo 2 on at

Like (0)

Report

Another options is to deploy Azure Data Factory pipelines that extract data from Business Central Online to Azure SQL. You can also extract the data to an on-premises SQL Server setting up the ADF Integration runtime.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,746 Super User 2025 Season 2 on at

Like (0)

Report

Hi, hope the following helps.

Dynamics 365 Business Central SaaS: How to Export Database and Restore it on Local SQL Server

https://yzhums.com/5010/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,643 Super User 2025 Season 2 on at

Like (2)

Report

Hope this helps as well: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-extract-data

Was this reply helpful? Yes No
AH-31052106-0 249 on at

Like (0)

Report

Hello @Steven Randers, is it possible to export the data outside of the O365 environment?

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Yes, data can be imported into any database environment; it doesn’t have to be D365. It can be hosted on AWS, Azure, IBM Cloud, or other platforms.+

Thanks

Ramesh

If this helped you, please check the box Does this answer your question?

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,643 Super User 2025 Season 2 on at

Like (1)

Report

Check if this helps: https://skyvia.com/data-integration/replicate-business-central-to-sql-server

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,485 Super User 2025 Season 2 on at

Like (1)

Report
Another option is to use Configuration Packages to export data to Excel. However, the best approach depends on your specific needs. What do you plan to do with the data?

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No