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)."

     

Smaccallum's avatar
Smaccallum
New Member
3 years ago

I added a where clause in the sql statement block to narrow the results.  Once the M code showed up, I removed the where clause and canceled the evaluation.  Closed dataflow and refreshed.  Slow but works like a charm.

reachsarfaraz's avatar
reachsarfaraz
New Member
8 months ago

This worked for me too. Thanks.