keeping the data when a URL link refreshes

Alirezam  

I am afraid your requirement cannot be achieved. Power BI is an Interactive Data Visualization BI Tool. It is used to display data and store data.

For some extension, you can use R script to export data to CSV when updating your dataset, please check alanhodgson’s reply about this method in this thread.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

Hi Alirezam 

You could use Power Query in Excel and VBA to get and store the data.  You could then use the Excel Workbook as the source for Power BI.

Phil

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

Hi Alirezam 

I said use Excel to store the data, to save it.  Then use that workbook as the source for PBI.

You can't store data in PBI as you are wanting to do, so you'll have to load and store it somewhere else.

You can do this with VBA to load the data from the URL and then insert that data into a new row in an Excel table.

This table is the source for PBI.

You can either use VBA to get the data directly or use PQ and use VBA to refresh the connection.

This post describe the process and provides VBA code to do the work.

https://www.myonlinetraininghub.com/charting-real-time-data-in-excel

NOTE: That post uses Python to get the data but it's the same process when using VBA or PQ.

Phil

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.