We have incremental loads on several tables within our PBI EDW dataset. Due to a bug in our transformation tool, when I carry out a PBI deployment, I need to fully reload all partitions of all tables.
Currently we perform a regular refresh (current partitions) and then I use SSMS to refresh the historical partitions on each table one-by-one. This takes a couple of hours of tediously looking over to check when each table has been refreshed, so I can refresh the next.
Is there a way to trigger a refresh of all tables and all partitions at once?
Alternatively, is there a way to queues refreshes of all tables and all partitions so I can simply leave it running? Someone suggested Tablular Editor 3, but I'm yet to see if this is genuinely possible.
Thanks!
