Skip to main content

Notifications

Power Apps - AI Builder
Unanswered

How to improve the performance of using Power Automate with AI Builder?

(0) ShareShare
ReportReport
Posted on by 5

Hi,

  • I have developed a text classification model from the AI Builder which I need to run on a large number of records (around 1m records)
  • I have been able to run the AI model on around 1m of records using Power Automate to loop through each record in the Dataverse table (source data) however the performance is very slow - the Power Automate flow takes around 5 days to run which is not ideal 
  • I would like to improve the performance and reduce the execution time, I have been experimenting with various techniques such as by using parallel branches within the flow to split each branch by a period of month however it still seems to be taking a very long time!

 

  • What can I do to reduce the execution time?
  • Is 5 days a normal amount of time to run the AI model against around 1m records of text?
  • I am using a loop to go through the first 5k records in the Dataverse table, once this is complete I am using a do until loop to iterate through the remaining records (995k records) or so 

Thanks!

flow_screenshot.PNG

Categories:
  • anthony1694 Profile Picture
    anthony1694 5 on at
    Re: How to improve the performance of using Power Automate with AI Builder?

    Thanks for your suggestion, I have already done this actually 

  • CedrickB Profile Picture
    CedrickB on at
    Re: How to improve the performance of using Power Automate with AI Builder?

    You can set the parralelism level of the "do until" by selecting "..." then settings.

    That would allow to increase the number of text processed in parrallel.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard