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

[ShahrukhHB]

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

[nilendraFabric]

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`

[v-saisrao-msft · Accepted solution]

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.

[v-saisrao-msft]

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.