Hi there,
I have connected to SQL to get a table of around 1000 rows.
I then used PowerQuery to duplicate the source data in to 10 queries and filtered each so I can have 10 tabs in Excel showing relevant data.
However, when I make a change to the SQL database, only the initial table is updated.
Is there a way in which all versions of the source data can be updated when a refresh is performed?
Any help with this is greatly appreciated.
Thanks,
Greg
Bookmarks