Dear all
I have 2 different tables in 2 different files. (my source files)
I create a connection for these 2 source table (in a 3rd file)
I use append command and I am able to merge these two tables correctly in PowerQuery.
I load to this table to a sheet and I can do pivot table.
But when my source are updated my results don't be updated.
Because I need to create a pivot table with source of append table in power query.
My question is how to create a pivot table and to have latest data when an update occurs in my source tables with power query?
Best Regards.
Bookmarks