Power Query_Refresh data_Not populating

[ajay_tippu]

Hi,


I am newbie in using power query tool. I want to combine two sheets data in the same work book and then I want to apply pivot
So I used power query for two tabs and then append to combine both tables.

However, I will keep adding data to the 2 sheets which I combine, but whenever I refresh the query, newly added data will not be shown.


Please help me on this.


Thank you

 

[SorenPetersen]

It might be that your file is corruped - as it will not update with new data.

There are a number of operations you simply should not do:

- Change the table name in Power Pivot
- Rename an imported column in Power Pivot
- Delete an imported column in Power Pivot

They will corrupt the file. See the book "M is for (DATA) Monkey".