
Announcements
Hi!
I have developed a text classification AI model using the AI builder from within Power Apps
I would like to run this model against a large dataset – what is the best way to run the AI model against a dataset please?
I am currently trying to do this by using Power Automate to loop through rows in a table to generate new columns for the AI generated columns however this doesn't seem like the most efficient method as:
1. Takes a long time to iterate through rows (I read it will take roughly 30hrs to iterate 200k records)
2. Limit on 5k results from a dataverse table, which I am trying to solve this by developing a loop as part of the solution, keen to know if anyone has encountered a similar issue or knows how to resolve
What is the best way to run a text classification AI model developed from the AI builder against a dataset? For example, is there a method to run this custom text classification model via dataflow for example?
Thanks in advance
Hi @anthony1694!
Thank you for sharing your use case. Here's something you can try:
1) On your flow, select the ellipsis on the apply to each action that iterate all the rows on your table.
2) Select Settings.
3) Turn on the concurrency control setting and increase the degree of parallelism. This will make the apply to each action process multiple rows at the same time, instead of going sequentially one by one.
Hope this helps your flow go faster! 🚀