Create historical data within Power BI Table

[Anonymous]

Hi All,

I am pulling data from share point site & there we have always current month data only. But I want to keep previous month data as well in my table.

Example: Last month when I pull the data into PBI it was for 07-2020. Now, in sharepoint data has been replaced with current month data. But what I want is something like that I can keep 07-2020 data and append current month data into existing table. This scenario is for only one table not for whole application.

Is there any way that I can append data everymonth in particular table ?

[v-easonf-msft]

Hi , @Anonymous 

You can try to duplicate  the old query  before the next refresh time then you can uncheck the option "include in report refresh"  to disable the refresh of this copy data . Then you can append them as a new query.

You also can refer to this related thread.

https://community.powerbi.com/t5/Power-Query/Adding-daily-data-to-historical-table/m-p/863993

Best Regards,
Community Support Team _ Eason

[pranit828]

Hi @Anonymous 

It is only possible if the folder from where sharepoint pulls data is stores previous months data in different file name.

Another option, You might need to try Incremental refresh.

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh

Otherwise, If that folder has only this file and if it is getting updated then you might not be able to get old records.

Did I resolve your issue? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!!

Regards,
Pranit

[FrankAT]

Hi @Anonymous 

yes, you can do it with Power Query. Save your files in a folder and use query that extracts the data from all files inside this folder.

 Regards FrankAT