intermittent refresh failures: Data source timed out

[Anonymous]

Hi All,

I am getting "intermittent refresh failures: Data source timed out" erro so frequently.

Can anyone let me know the reason and solution for this?

Thanks & Regards,

Muni.

[v-diye-msft]

Hi @Anonymous 

Please try the solution provided by @venal , and then test below workaround:

1. Edit your report, in settings/options delete the data cache
2. Save your report to My Workspace
3. Perform a manual refresh there, if the report refreshes FINE then redeploy the report again to the correct workspace.  This fixes caching issues

if the issue still exists, please kindly raise it as support ticket for better advice:

https://powerbi.microsoft.com/en-us/support/ 

[venal]

@Anonymous 

May i know the data source you are using for the report?

Connectivity Mode (Import/Direct Query)?

Is Scheduled Refresh or On-demand Refresh, which one is failing?

What is the Gateway version you are using, if it is the older version please try to upgrade it to the latest version and try to re-pro the issue.

BR

venal.

[Anonymous]

Hi Venal,

Thanks for your time.

PFB details:

 Data Source                  : Hadoop

Connectivity Mode        : Import

Scheduled/On-demand : Scheduled

Gateway version            : July version

Regards,

Muni.

[venal]

@Anonymous 

Thanks for the quick response.

can you please try to upgrade to the latest version from the below link and try to re-pro it.

https://www.microsoft.com/en-us/download/details.aspx?id=53127

If you have any concerns, please let us know.

BR

venal.