We have been having on and off refresh issues for months
The issue seems to be caused by time out error while using the PBI gateway and I note several instances of similar issues being reported here but with no solution being offered. Our Appliction Management team say that the Gateway is up and re-starting the gateway does not fix the problem.
The issue can often resolve itself, but we have to wait hours, or sometimes even days. This is having an organisational impact as key business reports are not being made available on time.
Here is the error code from one of our failed reports this morning:
Data source error: {"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":"Timeout expired. The timeout period elapsed prior to completion of the operation."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.HostingError.Reason","detail":{"type":1,"value":"Timeout"}}],"exceptionCulprit":1}}} Table: (xl)Firm Cohort.
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: c4553a4e-6073-45d5-a96d-841692af8899
Request ID: 39cbf385-13bb-491a-b237-b01ca89dedd5
Time: 2023-06-21 08:10:59Z
Can this be investigated?
Thanks
SC
on:
Copying Table with Filters is Ignoring Filters
v-xiaoyan-msft
on:
Default Chart - Shape Map Is Not Working As Expect...
Hi @SCottrell ,
The error message haven't provide more specific reason, as you said, it seems a time out error. There could be a number of reasons why this error is occurring. One possibility is that the data source is too large or complex for the system to process within the allotted time. Another possibility is that there is a problem with the network connection or server that is preventing the data from being retrieved in a timely manner.
If all these aspects don't help, to get the root cause, I suggest you create a support ticket, a dedicated engineer will come to help you dig the problem.
Best regards,
Community Support Team_yanjiang