Looking for Historical 60+ Days Tabular Weather Data

[Anonymous]

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! 

[v-shex-msft]

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]

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

[v-shex-msft]

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