Hello, i am wondering if i can changes the source data if i made changes to the power query reports. Here's the case scenario:
I have multiple workbook in one folder, i have formatted all the workbook with the same table name
Then i started a new file and get data from power query to combine the file with the same column name like this :
But my question is, is there any way if i made changes to the power query report in file pq.xlsx, so the date on the source file will also be changed?
for example here:
i made changes on B6 and C6 which are the data on file Data2.xlsx. I wonder is it possible that the data on Data2.xlsx changes automatically after i made such changes?
If it's not possible with power query, is there any tools to make this work? Thank you.
I have multiple workbook in one folder, i have formatted all the workbook with the same table name
Then i started a new file and get data from power query to combine the file with the same column name like this :
But my question is, is there any way if i made changes to the power query report in file pq.xlsx, so the date on the source file will also be changed?
for example here:
i made changes on B6 and C6 which are the data on file Data2.xlsx. I wonder is it possible that the data on Data2.xlsx changes automatically after i made such changes?
If it's not possible with power query, is there any tools to make this work? Thank you.