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

Vaibhav Patil 235 Reputation points
2024-09-05T19:17:12.3733333+00:00

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.

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,741 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,568 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
21,382 questions
Dynamics 365 Training
Dynamics 365 Training
Dynamics 365: A Microsoft cloud-based business platform that provides customer relationship management and enterprise resource planning solutions.Training: Instruction to develop new skills.
121 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. phemanth 10,240 Reputation points Microsoft Vendor
    2024-09-06T11:20:12.05+00:00

    @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.

    1. 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

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.