Problem with query based on source table in Power Query|Power Query|Excel Forum|My Online Training Hub

Hi Guys,

i am importing CSV table called "Table1.csv" into workook.
I have in workbook Table2 which i am merginf with Table1. 

Table1 from CSV:

Col1Col2Col3

1	2	3
4	5	6

Table2 in workbook:

Col1Col2

1	A
4	B

 

And i am getting result in Merged worksheet (i am combining this 2 tables with inner join):

Col1Col2Table1.Col2Table1.Col3

1	A	2	3
4	B	5	6

It is working perfectly.

Problem is that source data will be removed or server where i have this data turn off. Table1 source will be not available for user!

And now if i want to get Merged result using refresh i am getting error

- Could not find file" C:/...." (file address in my computer). 
Table1 was already imported once from CSV so i have already data inside workbook. 
How can i fix the error not having CSV file source anymore? 

Am i force to create another PQ table based on already imported source ? (imported Table1 data?)
Or there is another possibility to skip this? 

Please help,
Jacek