Forum Discussion
Create historical data within Power BI Table
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 ?
3 Replies
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
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,
PranitHi , 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
