Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Christann
Helper IV
Helper IV

How 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 4

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)

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

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

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors