topic How to create Connection with Business Central Web Service API's using Fabric Notebook with OAuth2 in Data Warehouse

How to create Connection with Business Central Web Service API's using Fabric Notebook with OAuth2

ShahrukhHB — Wed, 05 Mar 2025 08:33:51 GMT

Hi Members,

I created 1 Workspace and Get some Data from Business Central Web Service API's then i Applied incremental Refresh.

Incremental Refresh does not allow to Load the Data in LakeHouse so i am loading them into Warehouse.

Now my Question is i want to Load first into Lakehouse then I want to Load data into Warehouse with Partition for that i want to Use Notebook in Lakehouse to fetch data from Business Central.
But when i am trying to use That API on Web Getting Below Error

{"error":{"code":"Authentication_InvalidCredentials","message":"Web service access key is no longer supported as authentication. Please use OAuth.  CorrelationId:  eacc619a-d1f0-48ee-812d-5e7929ecfd0f."}}

also Suggest me Best Way to create Warehouse for Business Central.

current Approach Businss Central Web Service API ------------> DataFlow Gen2(With Incremental Refresh)-------------> Load into Warehouse

Re: How to create Connection with Business Central Web Service API's using Fabric Notebook with OAuth2

nilendraFabric — Wed, 05 Mar 2025 20:23:36 GMT

Hello ShahrukhHB

seems like you are using Basic Auth which is deprecated. Use OAuth2 with Azure App Registration

Redirect URI: `https://businesscentral.dynamics.com/OAuthLanding.htm`

API Permissions: Add `Dynamics 365 Business Central` with `API.ReadWrite.All`

Re: How to create Connection with Business Central Web Service API's using Fabric Notebook with OAuth2

v-saisrao-msft — Fri, 07 Mar 2025 11:42:48 GMT

Hi ShahrukhHB,

Thank you for reaching out to the Microsoft Fabric Forum Community.

The error message indicates that Web service access keys are no longer supported for authentication when accessing Microsoft Dynamics 365 Business Central APIs. You are required to use OAuth2 authentication instead.

For your reference:

Web services authentication" - Business Central | Microsoft Learn

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.

Re: How to create Connection with Business Central Web Service API's using Fabric Notebook with OAuth2

v-saisrao-msft — Mon, 10 Mar 2025 05:03:31 GMT

Hi ShahrukhHB,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.