keeping the data when a URL link refreshes

[Alirezam]

Hi Experts,

I have a URL link that refreshes the data every 2 minutes. I am able to read the data and pull it in power bi. However, every time that the link refreshes, I miss the old data and the new one replaces. I want to keep all of the past data. Is there any solution? I attached the snapshot. and here is the link:

https://airbox.edimaxcloud.com/api/tk/query_now?token=2fa2fa51-696c-4c75-8a8d-cce57ccd6006

[PhilipTreacy]

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.

[PhilipTreacy]

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.

[Alirezam]

Thanks but what you mean when you say use an excel file to restore? Of course, this is obvious that we need to restore the data in an excel file. the problem is we need to add rows instead of re-writing them as explained before. thanks

[Anonymous]

@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.