Forum Discussion
Unable to refresh data in Power BI service
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
1 Reply
- AnonymousNot applicable
Hi DenNor ,
The issue has been mitigated now, please have a try.
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.