Getting API Keys for all cities

[Anonymous]

Hello all,

I'am trying to connect Power BI to a weather website and obtain current weather for specific cities. I have called the API key for one city, please help me do the same for all cities.

Thank You

[v-micsh-msft]

You may follow the article below:

Creating a Weather Dashboard with Power BI and API

Which offers you an example of the walkthrough, including the Cities ID.

Regards,

Michael

[Anonymous]

Hi Michael,

I have prepared my dashboard with the help of the link you have provided.I have been able to connect to different cities.But my major concern is that the users will have to go to the query editor everytime they want to see a different city. What I'am looking for is a filter for cities because going to the back end and making changes for every city is not user friendly. Can something be done so that there is no dependence on the pbix file and the developer can make the necessary arrangements for the end users?