Forum Discussion
Connecting with Dynamics 365 Business Central using data pipeline
I'm trying to connect Dynamics 365 Business Central with my Fabric workspace. I know that it is possible to receive data from Business Central using dataflow gen2, but i'm wondering if there is any chance to receive data from BC into data pipeline not dataflow gen2?
13 Replies
- NandanHegde
Super User
As long as there are APIs to extract data from a system, you can use Copy activity to copy data from them.
Azure data factory is similar to Fabric data pipelines
Hi elpaloo ,
Thanks for using Fabric Community.
You can also have a look into below links along with the links shared by NandanHegde .
I hope these links might you.
Docs to refer -
First Post: Export Your Dynamics Data to Microsoft Fabric or Azure Synapse – Part 1 of 4
Second Post: Setup Synapse link or Fabric link - Part 2 of 4 (dynamics.com)
Third Post: Build your data warehouse as lakehouse on Dynamics 365 data in Microsoft Fabric - Part 3 of 4
Fourth Post: Update your Dynamics 365 lakehouse with incremental data updates using Change Data Feed - Part 4 of 4
Additional Links:
Solved: how Do I connect Dynamics 365 with Microsoft Fabri... - Microsoft Fabric Community
Hope this is helpful.Hi elpaloo ,
We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .
Thanks
It should be similar, but in copy data activity, rest connector does not support any valueable authorization (only Anonymous). So there is no chance to extract data from Business Central to Fabric 😞
Hello guys,
Thanks a lot for the documentation links. I read it all, and now I'm trying to create a connection, but I prefer to do it without Dataverse. An OData connection seems to be the proper way. I have one thing to consider:
- When I create a connection with the "Manage connections and gateways" tab in settings, the connection uses OAuth 2.0 authorization. However, I cannot use it in the Copy activity in the data pipeline. Creating a connection to the source in the Copy activity tab only offers Anonymous or Basic authorization, and it gives me an "Invalid credentials" error (In the "Manage connections and gateways" tab in settings, the test connection was successful). Maybe I need to create a gateway to Dynamics 365? Do you have any ideas?
Hi elpaloo ,
Thanks for your reply. I assume you are following the same - Data source management - Microsoft Fabric | Microsoft Learn
I just want to know are you not able see the connection in Copy Activity that was created at Manage Connections and gateway ?Yes, you right.
What's more, only OAuth 2.0 gives me opportunity to connect. Basic authorization throw an error "Invalid credentials" (I'm using the same credentials as in OAuth 2.0)
Maybe I should configure Business Central? Maybe BC won't let me in
