Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Data Gateway Query Execution Report - huge value for DataProcessingDuration

Using Enterprise Gateway  I am seeing some large numbers for DataProcessDuration. For example one value is 637,328,255,004,381 ms.  These large values appear to be random. They show up on different data sources including AD, SQL, SSAS, and SharePoint for different dates and time. The query reports as successful in each case. These very large numbers, though only a small percentage overall, skew the reports too a point where I will either have to replace the value with some average over time or delete the record all together.

 

Anyone else see this trend? Any thoughts of why these values are apparently incorrect yet the data suggest the refresh had no issue and reports a success?

 

Thanks

 

 

Status: New
Comments
v-yuta-msft
Community Support

@dbishop ,

 

I would suggest you create a support ticket here for further analysis.

Support Ticket.gif 

Regards,

Jimmy Tao

jol
Regular Visitor

@dbishop,

 

I am having a similar issue with some values for DataProcessingDuration(ms) being very large (such as 63,735,264,648,916). Do you ever get to the bottom of this?

 

What version of the Gateway are you using? I'm on 3000.54.8 (August 2020). 

 

Thanks,

Joel

cognovo
Frequent Visitor

Same here. Some rows have big numbers for DataProcessingDuration(ms) that seem to be incorrect. 

Example:

d0158dff-5777-4921-aa54-71b74b2f8220,2021-11-07T15:01:19.6198462Z,10635,Refresh,0,593.7439,1421.679,159479215,2021-11-07T15:02:57.5642698Z,63771894177564,Y,

d0158dff-5777-4921-aa54-71b74b2f8220,2021-11-07T15:01:19.6198462Z,10635,Refresh,0,593.7439,1421.679,159479215,2021-11-07T15:02:57.5642698Z,63771894177564,Y

 

Query Execution Duration about 10 seconds and DataProcessingDuration: 63771894177564 

Sokon
Advocate V

I suggest voting for this feature in order to get Microsoft's attention!