Forum Discussion

JayTill's avatar
JayTill
New Member
7 years ago

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

  • JayTill's avatar
    JayTill
    New Member
    7 years ago
    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
  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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