cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
blockwoodPAL
New Member

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 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 cardcheese.png

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.

1 REPLY 1
Mariusz
Super User II
Super User II

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.

 

 

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors