Forum Discussion
Advocate IVHow can I save past data while refreshing to new?
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
4 Replies
- rafaelmpsantos
Responsive Resident
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
