Forum Discussion
Advocate IPower BI Report refrershes failing with Timeout Error using Data Gateway.
Power BI Report refrershes failing with Timeout Error using Data Gateway from 31st Dec. we are currently running on November 2023 update (3000.198.17). Even the Gen2 Dataflow is also failing when refreshed Manually or scheduled. This issue seems like a Service bug. Similar situation occoured during 1st and 2nd week of Dec 2023 also.
Error Messages We are gettin on different datasets on different Data sources, not any particular datasource or dataset. This similar issue we have faced in starting 1st Week of Dec 2023 also that time we have upgraded the Gateway version and the issue was gone for couple of week now again it has started from 31st Dec. Microsoft Article says it support Gatewya for last 6 release. For a Large enterprise runnig large scale data refresh and power bi environment if this kind of issue happens very frequently there is a problem/bug with the service release for Power BI service that needs to be fixed ASAP. As we are running it enterprise wide there should be a minimal time or support for the gateway as it is very difficult to updated anything on a daily basis espacially during the Holidays where you have to deal with change freeze. and this this refresh issue happens for critical reports.
1.
{"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}}}
2.
{"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}}}
3.
{"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}}}
This issue was related to some networks firewall rules running on the background for One of the Gateway server.
We have 2 server cluster Gateway and in one of them the netwok traffic rule was blocking the outbound traffic on port 80. and that was causing the issue.
Thank you everyone for quick reply and support.
I was able to work with our Network team and finally resolve this.
6 Replies
- collinq
Super User
Hi sushovan93 ,
Basically, this message is stating that the gateway can't get the information.
Since all those messages talk of the gateway, I would start there. Is the gateway up and running? Is the network workign fine? Is the gateway up and running BUT the memory is full?
Second, if the gateway itself is fine and the gateway server is working then check the data source. Is it up and running and not maxed out? Is it responding on the network?
sushovan93We checked the gateway and it's running fine. the memory usage and the resource usage on the gateway server is also normal. we can conect to the data souce from Desktop and refresh it fine. sometime the refreshes did completed fine.
- collinq
Hey sushovan93 ,
If it works sometimes and not others then the timeout issue is often caused by the data source (or the network) being unable to process multiple requests at the same time. If you have three or four (or maybe only two) reports hitting the same dataset at the same time it might be overwhelming the datasource and causing one (or more) of the reports to fail.
You may want to run diagnostics on the datasource server to see if it is being overwhelmed at any point during the timeframes in question.
- sushovan93
My data sources are different for different reports and schedules are also running in different time.
Lats time when similar issue happened I had to upgrade to Nov version and that fixed the issue.
- sushovan93
This issue was related to some networks firewall rules running on the background for One of the Gateway server.
We have 2 server cluster Gateway and in one of them the netwok traffic rule was blocking the outbound traffic on port 80. and that was causing the issue.
Thank you everyone for quick reply and support.
I was able to work with our Network team and finally resolve this.- collinq
