I am currently putting together a report for a client that tracks visitation to a theme park. One of the requirements is to know what the weather was doing on a particular day. For instance they would have a report. that show that the max tempature for a day was 85 degrees and they had 1000 people come into the park. The issue is that in their current database we have the vistation information but NOT the weather. Does anyone know how and where I could get the weather information free. Is there an API I can call and get the information? Maybe a service I can call and get the past information and put into a dataset but also get the forecasted information.
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.