Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Does Dataflow evaluation stop after 10 minutes?

I am using a dataflow to query JIRA using REST API's. I moved the query from Desktop to Power BI Service/Dataflow hoping to benefit from using tables from multiple dataflows in one report. One of the...
dataflow
  • Anonymous's avatar
    Anonymous
    5 years ago

    I created a Support ticket.  I got the response I got from Microsoft is as follows:

    The authoring limit on Power Query Online is 10 minutes per query. This is the reason for evaluation cancellation error during dataflow creation. We cannot increase or decrease this timeout value. Please note that there is no such timeout value for Power BI Desktop. Reference Document: Power Query Online Usage Limits | Microsoft Docs

    You can consider optimizing the query or breaking the query into two to ensure that it takes less than 10 minutes each to execute. If in case, there is no way we can optimize this query. Then the only option left is to use Power BI Desktop instead of Power Query Online (dataflows)."

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi v-lionel-msft 

 

I have the exact same problem and tried your solution 

This is the code 

Source = Csv.Document(Web.Contents(Url, [Headers=[Authorization=AuthToken],Query=[start=StartDate,type="completion"], Timeout=#duration(0,30,0,0)]),
// I tried duration in all variation also #duration(0,0,30,0)])
    [Delimiter=",", Columns=29, Encoding=65001, QuoteStyle=QuoteStyle.Csv]),

But the evaluation times out after 10 min 

 


Any ideas how to increase the evaluation time ?

Best regards.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I did notice that certain other REST API queries lasting more than 10m went through, so it is not probably a timeout issue. On the other hand, there is no way to figure out what to do to resolve the problem - No diagnostics within Power BI service or details accompanying error message ...