How can I save past data while refreshing to new?

[Christann]

Hi all! I was wondering if it is possible to have my current data save as a new row in a "history" table whenever I refresh. In this way I would be able to see change over time. My data is gathered from the web, and has only about 3 rows each time. Any ideas?   --Christopher

[rafaelmpsantos]

Hi 
In these case you need to create a database in another place, like sql server azure... I do this using a sql server on azure and some R scripts.

I use power bi to collect the dataset on web, in another Step i insert this dataset on a azure sql server using R ( library RODBC) and then i get data from sql server with powerbi. (now all the historic data)

[Christann]

Sounds really great! How can I do this if I know nothing of the R language?

[rafaelmpsantos]

wel well ...its a big problem... 

if you know something of portuguese i have a video in my channel showing how to do this.

https://www.youtube.com/watch?v=lEuxDWxiPek

[Christann]

So sorry, I don't know portuguese. Thank you for your help though! Perhaps I just need to learn some R script!