Forum Discussion
Data from Dynamics 365, keeps returning; There was an error when processing the data in the dataset
In Desktop the update is working fine.
I've tripple-checked all access credentials, and I've tried deleting/republishing again multiple times.
In PowerBI Service I'm getting this error;
There was an error when processing the data in the dataset
| Data source error: | {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"OData: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Dynamics365BusinessCentral"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"Dynamics365BusinessCentral"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: PurchaseInvoicesLines. |
| Cluster URI: | WABI-EUROPE-NORTH-B-redirect.analysis.windows.net |
| Activity ID: | f140e6b8-3d5f-4129-8978-198ba3f1dfec |
| Request ID: | 9710bf96-c3f5-47d5-ceef-97d4ac9645b4 |
| Time: | 2023-02-08 11:12:04Z |
1 Reply
Did you ever fix this as I am currently getting the same thing.
I have several Semantic models based on Dynamics 365 Business Central power BI connector and 2 of them are producing this error.
