Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Question on refreshing data sourced from web

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!

Need Help
Show and Tell

3 Replies

  • vomi0401's avatar
    vomi0401
    New Member
    5 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.