How To Keep Historic Data In Power BI - Advanced Query Editor Concepts

Power Query
1

Hello,

I want to keep historical data to track of some KPI’s in past months, However, my file automatically refresh for current month data. is there any way I can keep old data in the data table?

Thanks