cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Jkilb Regular Visitor
Regular Visitor

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! 

3 REPLIES 3
Community Support Team
Community Support Team

Re: Looking for Historical 60+ Days Tabular Weather Data

HI @Jkilb ,

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Jkilb Regular Visitor
Regular Visitor

Re: Looking for Historical 60+ Days Tabular Weather Data

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

Community Support Team
Community Support Team

Re: Looking for Historical 60+ Days Tabular Weather Data

Hi @Jkilb ,

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 63 members 996 guests
Please welcome our newest community members: