How to integrate business central data to fabric onelake

[pavannarani]

Hello,

We have been working on a requirement to connect and pull the Business central data to Fabric. Can any one list out the steps to be followed how to setup the integration between these two systems:

1. How to built a datawarehouse solution for business central database in fabric onelake architecture

2. How to load historical data 

3. How to setup incremental refresh once we have the data in fabric

Regards

Pavan kumar

[collinq · Accepted solution]

Hi @pavannarani ,

That is not really something that can be answered in a forum with any degree of certainty or "correctness".  These are the questions that a consulting firm can help with in setting this up as the variables are almost endless and each decision begets another decision.

As far as a technical how to connect, you can start with this article: Introduction to Microsoft Fabric and Business Central - Business Central | Microsoft Learn  and then read all of the related articles and take the e-learning modules.

[Jerome22]

Hi

I'm using bc2adls

Releases · Bertverbeek4PS/bc2adls (github.com)

ibnitially developped by Microsoft, the code was maintained by another developper.

this is working fine.

this extension create a copy of all the tables tou want and do the incremental process for you with no effort.

this saved us days of development, also it's way faster and cost effective than using dataflow v2 

part of the other advantages, this support deleted rows (which is very hard to support using dataflows or other tools outside an application).

so do a try.

until Microsoft release a mirroring feature for BC, this tool is the best option (at least for us)

[pavannarani]

@Jerome22  ok its nice feature so does it charge to implement it or can we download it and see how its working is it possible

[v-kaiyue-msft · Accepted solution]

Hi @pavannarani ,

With Microsoft Fabric, there is only one source for all data. So you don't have to move data to another data warehouse or data lake. It's based on OneLake.

You can extract Business Central data into OneLake. you must create a Lakehouse in MS Fabric. You have to create a Lakehouse in MS Fabric. for Business Central you have to get the data from Dataflow Gen2:

Here you can select the tables you want to have in OneLake. After publishing, you can set the refresh rate and see all your data stored in your OneLake.

More detailed information can be found at the link:

Let’s flow your Business Central data into Microsoft Fabric - Discover Microsoft Business Central (b...

Fabric decision guide - choose a data store - Microsoft Fabric | Microsoft Learn

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[MircoPallotta]

With this method actually you dont have access to BC tables but to BC Web services. So if for example you need more columns than the ones provided by the standard APIs you need to write your own custom webservices, which is not a difficult task but for sure time consuming and costly to maintain.

[pavannarani]

@collinq Thank you for the link i will go through the related articles and see how to setup connection between two systems and extract data. 

[collinq · Accepted solution]

Hi @pavannarani ,

That is not really something that can be answered in a forum with any degree of certainty or "correctness".  These are the questions that a consulting firm can help with in setting this up as the variables are almost endless and each decision begets another decision.

As far as a technical how to connect, you can start with this article: Introduction to Microsoft Fabric and Business Central - Business Central | Microsoft Learn  and then read all of the related articles and take the e-learning modules.