Store data from refresh of web page into a separate table

[blockwoodPAL]

I'm very new to Power BI so I'm not entirely sure if this is possible or not, but I am getting data from a website and really only one row that I want to embed into SharePoint site so that the numbers refresh daily.  It would be similar to a stock ticker sort of display.

So I am using this website https://www.ams.usda.gov/mnreports/md_da800.txt and only retrieving the row for 40 pound blocks and putting on a data card

So it is really basic and then I will schedule that to refresh so it updates the SharePoint site instead of someone doing it manually.

What I was hoping to then do is on refresh take that information and add it to a new table with the date captured so that we were capturing it for historical purposes and may be able to then report on the historical trend from that same report.  I don't know if this is feasible and may be overkill as what is most important is the refresh and removing the manual process.

Ideally I would like to do some conditional formating with the price to show if it is over our target price as well as change the right number from red to green depending on how it has changed.  Thanks in advance.

[Mariusz]

Hi @blockwoodPAL 

Power Bi can not add records, so probably you need to look for the third-party.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

solution.