Automate table-by-table refresh (in order) in a Premium Workspace — Pro user, looking for non-manual

Hi paulos 

You could use Power Automate or a Fabric Notebook to refresh each table in the order you want. You can specificy the table name that you want to refresh, then monitor the refresh of the table and only once that has completed would you then move into the next table.

Here is an example how to do this using Power Automate: Leveraging the Advanced Refresh API using Power Automate - minceddata - Obsidian Publish

To do it in more detail with the monitoring you need would be a consultant who can do this work for you.