Forum Discussion

rajharsh's avatar
rajharsh
Regular Visitor
2 years ago

Desktop error: ODBC: ERROR [Microsoft] (115) Operation Timeout: Timed out polling the job

Hello Community

 

I have a table with around 3 years of data having 4 columns and trying to load around 300K rows. I was able to load this table without any worries in the previous versions like September 2022. However, with the the new version (September 2023) I am getting this error. "ODBC: ERROR [Microsoft] (115) Operation Timeout: Timed out polling the job"

Any leads here are appreciated.

 

Need Help

3 Replies

    • rajharsh's avatar
      rajharsh
      Regular Visitor
      2 years ago

      Hi Dangar332 -

      Thank you for the response.

      I have tried setting the timeout to 30 minutes as well. But didn't solve the error.

      CommandTimeout=#duration(0,0,30,0). 

      Should I increase the timeout to 40?

  • rajharsh's avatar
    rajharsh
    Regular Visitor
    2 years ago

    Update:

    I downgraded the PBI version from Sep 2023 to July 2023. 

    Ran the tests - I can load 2 rows of the table now using parameters and apply those changes to the data model. And the refresh on the PBI service completed successfully. (With the Sep 2023 version, this wasn’t the case).

    However, while loading the entire table at once, I am still facing the same error. (I have also tried out CommandTimeout in the m-query with 30 mins and 50 mins duration).