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. Wha...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    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.

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.