Evaluation was cancell

Anonymous 

Power query online or dataflow gen1 /gen 2 evaluation time limit is 10 mins. If it exceeds then it will fail. 

What is your datasource? What is the data volume? From the picture you shared, query folding is not happening. 

My suggestion is to click on the very initial steps of your query, for example the nvigation step, it should load quickly and then add a transfroamtion to limit the number of rows to 100. And then, make the change that you want to perform. And then, before clcik on submit/close and load. Remove the "Row Limit" transformation. 

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

hi Anonymous 

To resolve your issue:

1. Break Query into Smaller Parts: Divide complex steps (like merges and appends) into smaller, independent queries.
2. Disable Data Preview: Turn off the "Enable Load" or preview option to avoid long evaluation times.
3. Filter Rows Early: Apply filters at the earliest step to limit data volume.
4. Test Each Step Incrementally: Evaluate one step at a time to isolate the problematic step.
5. Switch to Gen 2: Recreate the dataflow with only essential steps to test performance.

This should help identify and resolve the bottleneck efficiently.