Forum Discussion
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.
I don't think I will mark any of the answers as the solution. I've seen the link GilbertQ shared and although it seems interesting I'm surprised at the complexity we would have to deal with just to do such a simple task as it is to partial refresh a dataset. I would have to see the answers in more detail but I don't think I will mark them as solutions. You tell me if it's mandatory to do it.
Community SupportHi paulos,
Please check the response from Poojara_D12 as it addresses your scenario. He explains that XMLA/TOM and sempy-based methods may not work as expected due to token and permission limitations in Pro environments.Also suggests using the Enhanced Refresh API with a Service Principal, which supports table-level (partition) refresh in Premium workspaces.
Thank you.
I always feel kind of pressured to accept as solution things I don't consider as solutions. I don't think that's a fair way to portray to the world that something is really solved but sure, I will accept the first one. Both of them are helpful although for me either really are what I was looking for but I appreciate the information.
