Forum Discussion
Copy Data From One Query, Append to Another
I know how appending tables works, but that is not exaclty what I would like to do. Here's what I'm looking to do. 1. Table A updates daily. 2. I want to use a query to Copy all data from Tabl...
Hi Anonymous
Power BI is not a database. It cannot store historically refreshed data into another table/query. Every refresh in Power BI is to reimport data from its datasources.
You need to backup Table A's data into another data source (database, excel file, csv file, ...) outside of Power BI. Then connect to this backup data source to get all data with Power Query.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.