Store data from refresh of web page into a separate table
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 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.