Gateway timeout error

[theu1996]

Hi,

At my company, we have developed a number of PBI reports, the majority of which import their data from a series of Excel sheets on our network drives. All of the reports have been running on the same gateway setup and were working fine until last week when every one of them suddenly started sending me the error message below.

I can manually refresh a few of them in the Desktop app, where the refresh still works, for the time being but it's not ideal. Could there have been too many reports using the same gateway? And even now if I try to use the refresh button on PowerBI.com, it says it timed out after 3-5ish minutes.

Thanks

[v-yiruan-msft]

Hi @theu1996 ,

It seems to be a timeout error... Please check if the solutions in the following threads can help you solve problem:

Refresh Failing-Timeout

New Gateway setup timeout

How to set command timeout option

In addition, if the data model is very complexity or the size of dataset is very large, it will cause timeout error. So please try to optimize the data model and reduce the size of dataset.

Best Regards

Rena

[riyadhiut]

Facing Same problem.