Hi,
I am hoping to get some guidance please,
I have developed a text classification model using the AI Builder from Power Apps.
Challenge
I need to be able to run the AI model against many records (around 1M or so) on a monthly basis
What is the most stable way to run the AI model against my table? It is currently stored in a dataverse table
Is the best method to use the database sync option available from the AI builder or is it to use Power Automate to loop through each record and apply the AI to the record?
Currently I have developed a Power Automate solution to loop through each record which generates AI columns for each record in an output dataverse table
Is there any guidance or documentation on how to use the database sync feature from Power Apps to achieve this? As I think this may be an easier option but I am not sure how to use it
Thanks,
Anthony
The approach to list records in Power Automate and use below task to iterate through records is the best way