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

Export data from BC

(6) Share

Report

Posted on by AH-31052106-0

286

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,547 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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,686 Moderator on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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 99,086 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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. 22,130 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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 286 on at

Like (0)

Report
Copy link

Link copied!

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,547 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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. 22,130 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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 32,208 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
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