Historical Data Storage

Hi everybody,

I have a question regarding historical data in Power Bi. I have a source where data is real time. I need to pull the data from there every day, but also I need a way to store it. If there is an approach with the help of which I could save data daily in Power Bi or somewhere else, that would be awesome. I can`t find any information on this subject. To provide more background I have a big excel table that has some KPIs that are should be inputted on a daily basis. I`m looking for a way to automate the everyday refreshment of this data and to visualize everything. I think data should be firstly pulled to excel using Power Query and then to Power Bi, but storage problem remains the same. Thank you for your time.