Evaluation was cancell

[Anonymous]

Previously , My querry is load ok with dataflow gen 1 , Suddenly when i need to edit, i open it and cant load anymore , take to long and after 10 minutes , it just show like the pictures, i tried to changed to dataflow gen 2 but still the same , anyone in the same situation?

[tharunkumarRTK · Accepted solution]

@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!

[v-menakakota]

Hi @Anonymous ,

Thank you for reaching out to us on the Microsoft Fabric Community Forum.

As mentioned @tharunkumarRTK , the response may address your query. Please follow the steps provided by him.
Thank you Tharun, for offering a possible solution.

Regards,
Menaka

[v-menakakota]

Hi @Anonymous ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-menakakota]

Hi @Anonymous 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Regards,
Menaka.

[v-menakakota]

Hi @Anonymous ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[rohit1991 · Accepted solution]

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.

[tharunkumarRTK · Accepted solution]

@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!