Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

passing a filter value into an API

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?

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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 🙂