The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
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.