Daily Current, Hi and Lo temps for multiple cities

[JoshWeather]

Hello, I have attempted to use the HTML link for each forecast weather city in PowerBi in order to get daily current, hi and lo temps. This works good as I only need to refresh but since it is static to a location in the page, when there is advisories taking the place for some temps then I get blanks or inaccurate data as they shift. I am looking for another possible way maybe via API to get multi cities from 3 states with current, hi and lo's possibly in a grid/Excel format somehow. It is about 26 cities