Hello People,
We had a requirement to pull all the business central information to Fabric environment. So as of my research i found few ways to pull data from BC like
1. Using Standard APIs from BC - It is giving only the tables or APIs exposed by Microsoft its not giving other tables which are not exposed
2. Using BC Connector in Dataflows Gen2 - It is also working similar to Standard APIs because it is utilizing same Standard APIs connection to pull data
3. Using Fabric Link option in Dataverse - This option is available in Dataverse environment and had two different methods Data Synchronization and Data Virtualization both of them had different setup to link fabric data
4. BC2ADLS - It requires some setup and expertise to do in fabric and BC using azure
I have tried the option 1 and option 2 both are same am unable to pull all tables information from Business Central. Option 3 looks simple but virtual tables is not good option for large datasets as it might throw errors while refreshing the data and it requires some setup
Similar to Dataverse is there an option to link Fabric in Business central directly, as per my research I found its not yet implemented or not available. Are there any reasons for this because even BC will be there on Dynamics 365 or Dataverse only right, but fabric link is available only in Dataverse not in Business Central.
Thanks in Advance
