Question on refreshing data sourced from web

[Anonymous]

I'm quite new to PowerBI and hope to get some advice.

Let say I get the historical stock data from Yahoo Finance and loaded into PowerBI dekstop to perform some visualization and calculation. What should I do in order to refresh the stock data daily (automatically) since every day there will be a new data at Yahoo Finance as long as the market is opened? 

Hope to get some help and advice, thank you!

[vomi0401]

The issue is related to the link refreshing the same date.  Take for example this yahoo finance link.

https://query1.finance.yahoo.com/v7/finance/download/ES=F?period1=1463702400&period2=1621468800&interval=1d&events=history&includeAdjustedClose=true

When hitting refresh, the period2 date (1621468800) will remain the same, which means the data will only be current up to the date the link was pulled.  The question is, how to get this date to update in the link.

[halomo97]

Hi, did you ever manage to get this working? I'm trying to do the same thing. I used data from another website to get the current epoch time and used that as a parameter in the URL to get the up to date data. It works fine in Power BI Desktop but I can't refresh the data in Power BI Service unfortunately.

[v-yuaj-msft · Accepted solution]

Hi @Anonymous ,

Based on your description, you can configure a scheduled refresh. Please refer to the following document.

Configure scheduled refresh - Power BI | Microsoft Docs

Which connecting mode did you use? You can also try to use automatic page refresh if your models have at least one “Direct Query” data source. Please refer to the following link.

Automatic page refresh in Power BI Desktop - Power BI | Microsoft Docs

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.