DataSource.Error : Current connection intent is Read-Only.

[oreoChipsCookie]

I'm getting the following error trying to access and load line data (PO_lines) of a specific entity(PO). I can access and load the data of the itself just fine. It's the lines of that entity (PO) that's getting the error: 

DataSource.Error: Dynamics365BusinessCentral: Request failed: The remote server returned an error: (400) Bad Request. (Cannot modify a record. Current connection intent is Read-Only. CorrelationId: 1e325c7e-1770-4f02-b616-0266fb317077.)
Details:
DataSourceKind=Dynamics365BusinessCentral
DataSourcePath=Dynamics365BusinessCentral

I saw in another forum to use the following line on the Advanced Editor in the Power Query Editor but it didn't work. It still returns the same error.

Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, [UseReadOnlyReplica = false])

I can also access other tables just fine. 

How can I solve this?

[rajendraongole1]

Hi @oreoChipsCookie - as per snapshot the connection to the Dynamics 365 Business Central data source is being made with read-only intent that preventing you to edit or modify records.

can you check the api endpoint you're using is correct and that your account has the necessary permissions to access and modify the data in the po lines table. check this table is exposed to web services not restricted with read only content.

Reference Docu:

Compare REST APIs, OData, and SOAP web services in Business Central - Business Central | Microsoft L...

OData Web Services - Business Central | Microsoft Learn

Create users according to licenses - Business Central | Microsoft Learn

API (v2.0) for Dynamics 365 Business Central - Business Central | Microsoft Learn

Hope it helps

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!