Unable to View Business Central Tables/Entities in ADF Linked Service

Question

I am able to successfully connect to Business Central using the Dynamics 365 connector in Azure Data Factory (ADF). However, when trying to list the available entities, I am not seeing the expected Business Central tables or APIs. Instead, I’m getting entities such as ACIViewMapper (aciviewmapper) and other similar entries, which do not correspond to the tables or APIs I need from Business Central.Also while enabling the Dataverse Connection Setup , Microsoft Dynamics 365 Connection Setup in business central service connections getting error as : Error message:  The import of the integration solution failed. This may be because the solution file is broken, or because the solution upgrade failed or because the specified administrator does not have sufficient privileges.

Answer 1

@Vaibhav Patil

Welcome to the Microsoft Q&A and thank you for posting your questions here

It looks like you’re encountering a couple of issues with your Azure Data Factory (ADF) and Business Central integration. Let’s break down the problems and potential solutions:

1. Unable to View Business Central Tables/Entities

When you connect to Business Central using the Dynamics 365 connector in ADF but see unexpected entities like ACIViewMapper, it might be due to a few reasons:

OData URL Configuration: Ensure that the OData URL you’re using is correctly configured. Business Central APIs are often accessed via OData endpoints. Double-check the URL format and ensure it points to the correct environment and company.

Authentication Method: If you’re using Office 365 authentication, consider switching to Azure Active Directory (AAD) service principal authentication. This method is more reliable and often recommended for such integrations.

Entity Permissions: Verify that the user account used for the connection has the necessary permissions to access the required tables and APIs in Business Central.

2. Error in Dataverse Connection Setup

The error message you’re seeing during the Dataverse Connection Setup suggests issues with the solution file or administrative privileges. Here are some steps to troubleshoot:

Solution File Integrity: Ensure that the solution file you are importing is not corrupted. You might want to download a fresh copy of the solution file and try the import again.

Administrative Privileges: Confirm that the user account performing the import has sufficient privileges. The account should have system administrator or equivalent permissions in both Business Central and Dataverse.

Solution Upgrade: If the solution upgrade is failing, it might be due to dependencies or conflicts with existing customizations. Check for any dependencies that need to be resolved before the upgrade.

Resources

• Connecting Business Central to ADF: This guide provides detailed steps on setting up the connection using AAD service principal authentication.
• Troubleshooting Dynamics 365 and Dataverse: This resource offers troubleshooting tips for common issues encountered with Dynamics 365 and Dataverse connectors.