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...
Need Help
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 🙂