Forum Discussion

DenNor's avatar
DenNor
New Member
2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi DenNor ,

    The issue has been mitigated now, please have a try.

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.