Why do I get this error when refreshing a Dataset?

[JayTill]

Last refresh failed: Fri Sep 28 2018 09:48:26 GMT+0100 (GMT Daylight Time)
There was an error when processing the data in the dataset.Hide details

Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Table: MONTH_PandLDATA.

WABI-NORTH-EUROPE-redirect.analysis.windows.net

afa133b1-ea6c-4813-ac85-1514d1b0da39

cb3845c2-06f9-8195-b289-0d7b54d02c96

Cluster URI:
Activity ID:
Request ID:
Time:	2018-09-28 08:48:26Z

[v-juanli-msft]

Hi @JayTill

Do you connect to sql server on premises in direct query connection with power bi desktop?

Does "refresh" mean to clcik on the "Refresh" button on the "Home" tab of the power bi desktop

or "Refresh now" or "Schedule Refresh"  on  power bi service?

Was the refresh successful before?

Best Regards

Maggie

[JayTill]

Hi,

Keep getting this error when trying to refresh a dataset;

Can anyone tell me how to increase the time out period ?

Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Table: MONTH_PandLDATA.

WABI-NORTH-EUROPE-redirect.analysis.windows.net

afa133b1-ea6c-4813-ac85-1514d1b0da39

cb3845c2-06f9-8195-b289-0d7b54d02c96

 
There was an error when processing the data in the dataset.Hide details

Cluster URI:
Activity ID:
Request ID:
Time:	2018-09-28 08:48:26Z