Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Looking for Historical 60+ Days Tabular Weather Data

Hi, 

 

I'm trying to find a website that offers a free historical weather table with high/low daily temperatures and daily precipitation or rainfall/snow. I'm looking for 60 - 90 days of historicals that updates each day. I've found a couple websites that generate a report in pdf, but I don't believe I can connect to this type of data (for example, I have to specify which month I want which means this method would not auto update in subsequent months. I simply want to hit the "refresh" button in Power BI and have the report pull the URL's new entry each day). It would be much easier if I only had to connect my Power BI to a single URL (hence a URL that constantly updates each day with 60 - 90 days of historical data). 

 

I'm looking for weather in El Reno, Oklahoma (we can select another city in Oklahoma if this is too specific). 

 

Thank you for your help! 

Interesting Links
Need Help
Tips and Tricks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    HI Anonymous ,

    According to your description, I'd like to suggest you to parametrized your connection string with 'datetime.localnow' function to achieve dynamic date range filter.

    dynamic date filter

    parameterize connection

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi, 

       

      thank you for your response, but I think you miss-interpreted my question. I'm simply looking for a website that has 90 days of historical weather data in a table form. 

       

      Justin

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Anonymous ,

        I think you need to find out correspond weather info api(website used to get data) and use web connector get data from that api.

        Regards,

        Xiaoxin Sheng