Forum Discussion
Dataflow Gen 2 dataflow queries with PIVOT long running, never return results
Hi!
When you mention that this has never returned results, you mean during a refresh? or while you were inside the Power Query editor?
Could you take a screenshot of the query plan at the last step of your query? More information about the query plan feature below and how to get it:
When you mention that this has never returned results, you mean during a refresh? or while you were inside the Power Query editor?
Both.
Below is the dataflow query (named Data), that appends 4 tables and pivots on string column, waiting to show results. Note that the Source step does quickly show the appended results. It is the Pivot step that is the issue.
Below is the dataflow (named Dataflow 2) which is the above but Published, waiting to show results.
Below is screenshot of the above screen after maybe 20 or 30 minutes when it stops, shows the highlighted red triangle beside dataflow name, that pops the message about "The dataflow was could not be saved. The Model evaluation was cancelled. Please try again later."
Below is query plan which is also waiting to show results (I guess the query has to return results before the query plan can be shown?)