Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Appended data at each refresh

Hi everyone, 

 

I have put together a PBI report that connects to a goverment website, download economic numbers, and these numbers are used in reporting. Whenever the users refresh, they are presented with the latest figures. We want to be able to keep existing data intact, and append the new values in the dataset. I'd imagine I'll create a custom column to carry update time stamp on it. 

 

any ideas how to go about this?

 

Thanks

Kaz

Need Help
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    Anonymous Incremental loads is still not yet availabe in power bi desktop. You need to have middle layer database where you can do incremental load and then use power bi. You can vote for that idea here.

     

2 Replies

  • ankitpatira's avatar
    ankitpatira
    Community Champion
    10 years ago

    Anonymous Incremental loads is still not yet availabe in power bi desktop. You need to have middle layer database where you can do incremental load and then use power bi. You can vote for that idea here.

     

  • GeorgeR's avatar
    GeorgeR
    New Member
    10 years ago

    Hi 

    You only have update command for external data in PPivot. So I think that kind of timestamped manipulation ( append, insert into the table) should be done outside of your model using SQL commands, procedures. Once you have it you can sync it into your model and make selection, time machine display, etc.

     

    R

    George