Unable to refresh data set after timeout

[Anonymous]

Hi! Today I had a data set timeout, but when I clicked the refresh icon, the refresh would not start again. I clicked 3 times, allowing for a couple minutes in between and nothing. Has anyone else had this issue?

[Anonymous]

HI @Anonymous,

Can you please provide the detailed gateway logs and refresh history to help us clarify this and trace the backend processing error messages? 

How to Get Your Question Answered Quickly 

Regards,

Xiaxoin Sheng

[GilbertQ]

Hi there

What is the data source?

Are you using a Gateway to refresh the dataset?

[Anonymous]

The data source is SQL server and it's connecting through a data gateway.

[GilbertQ]

Hi there

Could you try and set up the timeout settings for your data source.

My blog post explains this in more detail https://www.fourmoo.com/2020/02/26/ensuring-your-power-bi-incremental-refresh-does-not-timeout-when-...