Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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.
Regards,
Xiaoxin Sheng
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |