Forum Discussion
Christann
Advocate IV
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 f...
rafaelmpsantos
Responsive Resident
Responsive ResidentHi
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! :smileyhappy:
