Hi.
Yesterday, my dataset startet giving the error "OData: Request failed: The remote server returned an error: (500) Internal Server Error." on the scheduled refresh in PowerBI services.
Im confused as to where to start..
- The gateway is running.
- I can refresh fine when refreshing manually on PowerBI Desktop.
- I have not done any changes.
- My dataset is not that large, maybe 10-12 million rows spread out on 5 tables.
- The error given refrences diffrent tables/rows each time
- And just to clarify, it's not set up with incremental refresh.
{
"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. (Internal Server Error)" } },
{ "code": "DM_ErrorDetailNameCode_UnderlyingHResult", "detail": { "type": 1, "value": "-2147467259" } },
{ "code": "Microsoft.Data.Mashup.ErrorCode", "detail": { "type": 1, "value": "10122" } },
{ "code": "Microsoft.Data.Mashup.ValueError.DataSourceKind", "detail": { "type": 1, "value": "OData" } },
{ "code": "Microsoft.Data.Mashup.ValueError.DataSourcePath", "detail": { "type": 1, "value": "https://api.businesscentral.dynamics.com/v2.0/<tenant-id>/<environment>/ODataV4/Company('<company-name>')/ValueEntries" } },
{ "code": "Microsoft.Data.Mashup.ValueError.Reason", "detail": { "type": 1, "value": "DataSource.Error" } },
{ "code": "Microsoft.Data.Mashup.ValueError.Url", "detail": { "type": 1, "value": "https://api.businesscentral.dynamics.com/v2.0/<tenant-id>/<environment>/ODataV4/Company('<company-name>')/ValueEntries? $select=Entry_No%2CAuxiliaryIndex1%2CItem_No%2CPosting_Date%2CDocument_No%2CInvoiced_Quantity%2CSales_Amount_Actual&aid=FIN&$skiptoken=1500000,'10938465'" } }
],
"exceptionCulprit": 1
}
}
}
Any help would be greatly appreciated—and if possible, a confirmation that the file size I have isn’t considered large.
