We are only able to refresh data in Power BI service, after restarting Microsoft Dynamics 365 Business Central Server and On-premises data gateway service. Does anyone have any suggestions as to what is wrong.
This is an example of the error-message we get, if we don’t restart:
{"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: Request failed: The remote server returned an error: (500) Internal Server Error. (An error occurred while processing this request.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"OData"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"http://weud....dk:7048/D..-LIVE-140/OData/Company('D..%20Prod')/GLEntries"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Url","detail":{"type":1,"value":"http://weud....dk:7048/D..-LIVE-140/OData/Company('D.. Prod')/GLEntries?$skiptoken=20000"}}],"exceptionCulprit":1}}} Table: Objekt
