Hello,
I am looking for a solution to integrate Microsoft Copilot with Microsoft Dynamics 365 Business Central On-premise. I would appreciate your guidance on the specific steps required to establish this connection.
Your expertise and detailed insights on this integration would be greatly appreciated. Thank you in advance for your support!
Best regards,
1
Answers
That said, if you're looking to build something Copilot-like or want to use Power Platform Copilot tools, there is a workaround using Power Platform + Custom Connectors:
- What You Can Do
You can connect Power Apps or Power Automate (and use Copilot inside them) to your Business Central On-Premise system via:
OData v4 or SOAP web services published from your on-prem environment
A Custom Connector created in Power Platform or via Azure API Management
An On-premises Data Gateway to securely expose those services to the cloud
Once that’s set up, you can:
Build Power Automate flows (with Copilot assistance) that read/write to BC On-Prem
Use Power Apps with Copilot to interact with BC data in a low-code/no-code interface
- Key Setup Steps
Make sure your Business Central instance exposes the right OData/SOAP endpoints
Set up the On-premises Data Gateway on a server that has access to BC
It’s not quite plug-and-play, but if you're comfortable with the Power Platform, this is a solid approach to bring some AI-powered experiences to your on-prem system.