Forum Discussion
DM_GWPipeline_Gateway_MashupDataAccessError The timeout period elapsed prior to completion of the op
Hello All,
Hoping you can provide some guidance on this intermitent issue we are facing. Small PBI Report will not refresh eventually due to the below error. Please note Gateway is running Latest Update and Server has been restarted as part of the troubleshooting. Source is n Azure DB feeding many other PBIs but there are 1 or 2 who every now and then will fail and provide the below error. Table indicated will vary in the final output of the error message.
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: DimXratesTreasury 2 USD.
Details why this should not be happening:
-Table DimXratesTreasury is only 780 rows
-Refresh in PBI Web Fails within just 1 minute of it starting
-PBI Desktop Report refreshes completely fine without any errors when refreshing at the same time in Desktop
-Every other Report in the same Workspace (premium) runs fine, all using same Source Synapse DB through same credentials.
Can anyone provide more details, Dont know if this is a Bug or something I can action on my side?
Thank you all!
Hi Anonymous
If it was intermittent I would then just leave it as something was not working 100% in the cloud platform.
If it is working well now then I would consider it resolved!
5 Replies
- GilbertQ
Super User
Hi Anonymous
Could you look at the logs in your source to see when refreshing if there is any error there?- AnonymousNot applicable
Thanks GilbertQ No errors in the activity of the Server. Weird thing is when the error was present during OnDemand refreshes in PBI web, the same PBI Desktop report could be refreshed without any error. Any other ideas?
- GilbertQ
Super User
Hi Anonymous
IT would sound like to me then possibly there is a connection timeout to this souce?