Power BI Connector for Microsoft Dynamics 365 Business Central

Build 24.0.9060

Business Central Endpoints

Microsoft Dynamics 365 Business Central supports several different endpoints to connect to data, with the two main categories being the Common Service endpoints, and the Web Services endpoints. Beyond that, each set of endpoints are split into Production and Testing endpoints. Production endpoints require an OAuth connection, whereas Testing endpoints may be connected to via User and AccessKey. Note that both Production and Testing endpoints access and interact with the same data - they just have different restrictions on what authentication methods are allowed.

Note: Basic authentication will not be supported for cloud version starting in Apr 2021.

The OrganizationUrl by default will attempt to resolve to a Common Service Production endpoint if any https://businesscentral.dynamics.com/ URL is specified. However, this may be configured by modifying the EndpointType. In addition, specifying any https://api.businesscentral.dynamics.com/ will override both EndpointType and UseSandbox as the specified OrganizationUrl supplied will be used without alteration.

Common Service Endpoints

Common Service endpoints contain the business data associated with Microsoft Dynamics 365 Business Central. For instance, accounts, sales orders, and sales invoices will all be found on the Common Service.

Common Service Endpoints - Production

  • https://api.businesscentral.dynamics.com/v2.0/{environment name}/api/v2.0
  • https://api.businesscentral.dynamics.com/v1.0/api/v2.0
  • https://api.businesscentral.dynamics.com/v2.0/sandbox/api/v2.0

Common Service Endpoints - Testing

  • https://api.businesscentral.dynamics.com/v2.0/{tenant id}/{environment name}/api/v2.0
  • https://api.businesscentral.dynamics.com/v1.0/{tenant id}/api/v2.0
  • https://api.businesscentral.dynamics.com/v2.0/{tenant id}/sandbox/api/v2.0

Note: The Tenant Id is the id of your tenant in Azure that the Business Central app is available on. This may be obtained by logging into portal.azure.com, selecting your user name, and going to Switch Directory. It may also be found under portal.azure.com, going to Active Directory, and Overview. Environment names may be found under https://businesscentral.dynamics.com/{tenant id}/admin.

Web Services Endpoints

Web Service endpoints include anything that has been custom exposed in Microsoft Dynamics 365 Business Central. This may include KPIs, reports, individual entites, or other feeds. In Microsoft Dynamics 365 Business Central, click the magnifying glass and search for Web Services to get an idea of what all are exposed by these endpoints.

Web Services Endpoint - Production

  • https://api.businesscentral.dynamics.com/v1.0/ODataV4/

Web Services Endpoint - Testing

  • https://api.businesscentral.dynamics.com/v1.0/{tenant id}/ODataV4/

Custom API Endpoints

To connect to custom API endpoints you need to set the OrganizationUrl property to your custom base url which is in the format: https://api.businesscentral.dynamics.com/v2.0/{tenant}/api/{API publisher}/{API group}/{API version}

Endpoint Default Changes from 2019

In the 2019 version, the default endpoint resolved to was the Web Services testing endpoint if a https://businesscentral.dynamics.com/ url was supplied to OrganizationUrl. The new default is the Common Service production endpoint. To continue using the Web Services testing endpoint, either set it directly or change the EndpointType to WSTesting.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060