Forum Discussion

bolarinwa's avatar
bolarinwa
Frequent Visitor
5 years ago

Refresh failed: Before the data import for finished, its data source timed out

Hello, I have just switched my data source from google drive to PostgreSql but then all my dashboards aren't refreshing anymore. See the error message below

 

 

Last refresh failed: Fri Oct 23 2020 12:19:01 GMT+0300 (Eastern European Summer Time)
Before the data import for finished, its data source timed out. Double-check whether that data source can process import queries, and if it can, try again.Hide details
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: d02f053a-fab1-4348-aaa3-129cabdb11e1
Request ID: 5abba6a5-232f-4217-b32e-9e4cc6c22c5e
Time: 2020-10-23 09:19:01Z

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    5 years ago

    Hi there

     

    The error is a data source timeout issue. If you can update your data source to have a longer timeout!

    • bolarinwa's avatar
      bolarinwa
      Frequent Visitor
      5 years ago

      Hi, thanks for your responses.

      I have updated the timeout in the data source. It works fine on desktop but on PowerBI online, it timesout after 2hrs though I set the timeout to 3hrs

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        bolarinwa Have you found any solution for this issue? I am facing the same issue. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi bolarinwa ,

    Do you mean that the schedule refresh failed after change the data source from google drive to PostgreSql? Whether the report can run and refresh successfully in Power BI Desktop after changed the data source to PostgreSql? Is there any other data source besides PostgreSql included in report?

    In addition, please follow the steps in the following links to extend the timeout duration just as GilbertQ suggested:

    Set a max run time / timeout for Power Query

    Setting Timeout Value in Powerquery

    Best Regards
    Community Support Team _ Rena Ruan
    If this post helps, then please consider Accept it as the solution to help the other members find it more.