How to refresh a table that is tied to a sharepoint form without going to the table every time

Hello!

I have a couple of tables that are populated from forms that various team members fill out and I bring this into a sales report via Power Query. For quite a long time, when I would refresh the PQ query that would bring in the new data, the table would auto refresh but awhile ago there was a change that broke this automatic refresh (I think a MS update from awhile ago?) and now I have to go to each table that has a form, open the sharepoint link, let it update, and then refresh my query to bring in the data.

This is an improvement from a share file that had too many issues with users entering wrong data and has been the best solution for a while but the having to manually go to each table and refresh it daily is driving me crazy.

What are my options to get this to refresh automatically if its within a form? I tried to dip my toe into power automate but for some reason these forms/tables do not show up within it and I have not had success using that (but I could also be doing it wrong).