Can not refresh dataset with Power Automate

[alks_skla_f]

Hello, I build easy flow in power automate, but I always get error:

How issue can be solved, please?

[v-lgarikapat]

Hi @alks_skla_f ,

i wanted to follow up and confirm whether you’ve had the opportunity to review the information  provided by @lbendlin ,

@Royel  If you have any questions or need further clarification, please don’t hesitate to reach out.

We truly appreciate your continued engagement and thank you for being an active and valued member of the community.

If you're still experiencing any challenges, please don’t hesitate to reach out we’d be more than happy to assist you further.

We look forward to hearing from you.

Best regards,
Lakshmi

[v-lgarikapat]

Hi @alks_skla_f ,

We haven’t heard back from you regarding our last response, so I just wanted to check in to see if you were able to resolve the issue. If you have any further questions or need assistance, please feel free to let us know.

Best Regards,

Lakshmi

[v-lgarikapat]

Hi @alks_skla_f ,

We haven’t heard back from you regarding our last response, so I just wanted to check in to see if you were able to resolve the issue. If you have any further questions or need assistance, please feel free to let us know.

Best Regards,

Lakshmi

[Royel]

Hi @alks_skla_f  

Looks like you're hitting the Power BI API too often, which is why you're getting that 429 "Too Many Requests" error. Basically, it's the system’s way of saying, "Whoa, slow down a bit!"

So lets slowdown the process a littlebit. You can add an "Delay" or "Sleep" at the begining or end of refresh a dataset and see how it performs, if not solved, gradually increase the delay 60 seconds then 120 seconds. 

Note: Seems like you are refreshinh only one semantic model right now, but if you try to refresh many semantic model at a time you could get this issue frequently. You can make it sequential or add "Delay" or "Sleep" activity to overcome the issue. 

Is it helped? ✔ Give a Kudo • Mark as Solution – help others too!

[lbendlin · Accepted solution]

You are being too pushy, running too many requests (that's literally what 429 means - too many requests).  Slow down, and only issue a refresh request if your data has actually changed.