Forum Discussion
DataSource.Error : Current connection intent is Read-Only.
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?
1 Reply
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:
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!!
