Forum Discussion

kolturra's avatar
kolturra
Helper IV
6 years ago

Append Power Query - After Refresh Append Same Data after Previous Data

Hi,

 

I am trying to create a project for myself in which i want on analysie Top100 Stock data myself in Powr BI

1. Top 100 Stocks data loaded in "Top100Stocks" table  came from https://www.moneycontrol.com/stocks/marketinfo/marketcap/bse/index.html. This is working very fine, when i refresh the data, data is getting loaded with new updates

 

Now i have created new query with name of AppendTop100Stocks in which i want to append everytime data refersh data one after the data, which i am not able to sucessfully can some please help or show me how to do this in Power Query. One more point what i have observed that my Append is alway showing Current time instead of showing refreshed time.

 

I am doing entire process wrong or may be knowledge issue

 

Please help me, this is the task i have assigned to my self in quarantine days. I have loaded my file in below link.

 

https://1drv.ms/u/s!AlYy4z7ZT6i2gaYPhtIJoosPmNJLuw?e=xQwWhY

Thanks,
K Raghavender Rao

 

6 Replies