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

[kolturra]

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

[v-frfei-msft]

Hi @kolturra ,

Hope this article can help you.

https://visualbi.com/blogs/microsoft/powerbi/historical-data-preservation-using-power-bi-dataflow/

Also you can refer to this case.

https://community.powerbi.com/t5/Desktop/store-historical-data-from-Power-BI-Online/m-p/128189#M5444...

[kolturra]

Can some one please help me

[artemus]

What you are trying to do is

1. Not supported by Power Bi

2. Against the terms of use of the website:

All stock call information on moneycontrol.com is the proprietary, confidential property of moneycontrol.com and cannot be repeated for any reason outside the moneycontrol.com . You agree not to repeat or rebroadcast in any way any of the stock call information made on moneycontrol.com for any reason whatsoever.

....

You may not resell, redistribute, broadcast or transfer the information or use the information in a searchable, machine-readable database unless separately and specifically authorized in writing by moneycontrol.com prior to such use

[kolturra]

Okie, sorry i didn't knew this..i will stop doing this project.Thanks for warning me...i will stop working on this dataset...but with regards to my question is their any possibility i can do it in Power Query?

[artemus]

Generally this kind of approach is used on SQL or similar databases which have all the data, but you don't want to download it all. If you wanted to cached copies of a web site, you may be better off using something like Microsoft Flow to store it in an archieve

[kolturra]

Can you please share article if you are aware of something like this.

Thanks

K R RAO