Dataflow error "evaluation quota"

(0) Share

Report

Posted on by ramzez

312

Hi,

I have a dataflow that runs once every 60 minutes and it fails three times per day. The error message is "The refresh for this entity couldn't be executed because the user has reached their evaluation quota. Try again later or consider reducing the overall evaluation usage of the user."

I would like to run my Dataflow every 30 minutes but then it just fails more times and has the same error message. What actions should I take to fix this because I would like to run the flow every 30 minutes?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

cchannon 4,702 Moderator on at

Like (0)

Report
Copy link

Link copied!

I could be mistaken, but I believe you are running into the underlying PowerQuery Evaluation Limits (link).

These limits are here because MSFT is not going to let you do something ridiculous like try to count the number of atoms in the universe: They have to put limits on it of some kind.

Most likely you're hitting that daily evaluation ceiling of 8 hours. Maybe try some performance optimization to make the query more efficient.

Was this reply helpful? Yes No
ramzez 312 on at

Like (0)

Report
Copy link

Link copied!

Does a Developer environment have the same limits as a Trial Environment?

I'm running the Dataflow in a Developer environment and the sum of the PowerQuery Evaluations is a bit over two hours a day which is the limit for Trial environments so that might explain the issue.

Was this reply helpful? Yes No
cchannon 4,702 Moderator on at

Like (0)

Report
Copy link

Link copied!

There you go. Switch to sandbox or production and you'll be all set.

Was this reply helpful? Yes No