Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |