cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JayTill
New Member

Why do I get this error when refreshing a Dataset?

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
2 REPLIES 2
v-juanli-msft
Community Support
Community Support

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
New Member

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

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.