How to create dynamic source for a pivot table from a append table in power query

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.

I solved.
I must refresh table in 3rd file.
Then pivot is fine