Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Concatenate data column after Refresh

I was wondering if you can keep the previous data and add to this data the refreshed data.

I am using an API to get some data (small amount) but I want to update this data every week or so. I found out that I can refresh it with the Power BI web app -> My workspace -> Datasets -> Open Menu of my dataset -> Schedule Refresh. 
This is very useful, but I want to keep my previous data and add to it the newly fetched data. This is do make some kind of KPI based on the workflow of a project. 

In the end, I would like to have a dataset filled with several colum, each column representing a "Refresh" update.

KPI

Best regards,
mqje

Need Help

3 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    5 years ago

    No, the model will only show the current results.  You would need to pull the data into SQL and append it to a history table then have your model pull from that history table.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you for your response, so there is no "pure" Power BI solution to this? Because we want to avoid using external options like a SQL server or a Python script.