passing a filter value into an API

[Anonymous]

I want to use an API to pull information on weather depending on the selected city.  Using the below as an example the user would select a city a list (or hopefully using the Filled Map visualisation) and that city name is passed into the API URL

http://api.weatherapi.com/v1/current.json?key=&q=[insert the city here]&aqi=no

Any idea how I achieve this?

[Anonymous]

Hi @Anonymous ,

Dynamic M query parameters can only be used in DirectQuery mode. But if you connect to the API, then a workaround is to use parameter instead of slicer for filtering.

First create a query parameter, then change the URL in the Advanced editor, like this.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks i'll give it a try however how do I make the list of values something that is selectable in a dashboard like you would with a slicer which shows a list of options tha you choose from?

Sorry if it obvious and I am missing it I am still quite new to PowerBi although I am lving it so far 🙂