Power Query - Historical Data

Hi , RayMundo00 

According to your descripiton, Do you want to get historical data refreshed every day?

First of all, Power Query is a management tool for data connectors. When the data of our data source changes, it cannot save the previous data and only reads the data that exists in the current data source.

If you want to keep the historical data for each refresh, then create a new table to save the daily refresh data. The first way is to obtain the data refreshed every day through excel export.

Export data from a Power BI visualization - Power BI | Microsoft Learn

Another way is to create a dataflow Gen2(This is the new feature in Fabirc), then set the destination of the saved data to the place you want to store, and then select the "Apeend" save mode; in this way, the data you refresh every day will be stored in your Apeend in the destination. You can connect the destination's data again, and then distinct data to achieve your needs.

For more information, you can refer to :
mslearn-fabric (microsoftlearning.github.io)

Differences between Dataflows Gen1 and Gen2 - Microsoft Fabric | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly