Forum Discussion

jsquaredz's avatar
jsquaredz
Advocate I
10 years ago
Solved

Query Timeout on update

I am pulling in an update from a web source, but this source can take 3 minutes + to return data.  Power BI times out before the server responds.  I would like to adjust this timeout timer.  Can we m...
Need Help
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    jsquaredz What you need to do is in power bi desktop go to query editor then right click your web data source and click Advanced Editor. This will give you access to M code behind it. You need to specify timeout interval in there manually. See below image and then should work hopefully.

     

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

jsquaredz What you need to do is in power bi desktop go to query editor then right click your web data source and click Advanced Editor. This will give you access to M code behind it. You need to specify timeout interval in there manually. See below image and then should work hopefully.

 

jsquaredz's avatar
jsquaredz
Advocate I
10 years ago

Thanks for the workaround.

 

[timeout=#duration(0,0,30,0)]))

 

Can you share these parameters?

 

Would like to see this as a setting in the query builder.

 

  • ChrisWilliams's avatar
    ChrisWilliams
    Advocate II
    9 years ago

    >>[timeout=#duration(0,0,30,0)]))

     

    This is a TimeSpan like parameter, with the values representing Days, Hours, Minutes, Seconds.

     

    So, this setting represents a timeout of 30 minutes.

    • jsquaredz's avatar
      jsquaredz
      Advocate I
      9 years ago

      Can you advise if its valid to go over for a given unit?

       

      For instance 0,0,0,90 instead of 0,0,1,30

      • ChrisWilliams's avatar
        ChrisWilliams
        Advocate II
        9 years ago

        This seems to be fine.  I didn't directly test with the Power BI client, but I tested with the TimeSpan class in C# (I'm a developer), and it didn't complain at all.