Forum Discussion

steveazure's avatar
steveazure
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

PowerBI power query refresh timeout in kusto after just 5 minutes despite longer setting in M code

Using Power Query to query Kusto and the query times out after 5 minutes even though I've set the timeout to 21 minutes, like this:

 

 

[Timeout = #duration(0,0,21,0), ClientRequestProperties = [#"query_language" = "csl"]])

 

 

[Timeout = #duration(0,0,21,0), ClientRequestProperties = [#"query_language" = "csl"]])

The query in question typically takes about 7-10 minutes when run directly in Kusto. How do I get Power Query to honor the 21 minute timeout interval?

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    steveazure 

    I remember there was a fix on kusto content last month regarding to timeout, but I could not find it. Try update to newest desktop version see if still happends.

     

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

  • steveazure's avatar
    steveazure
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    Thanks but I'm already on the June 2021 version of PowerBI and the timeout issue happens on the published report/dataset too.

     

    Any other ideas?