Forum Discussion
Need to run API based on Filtered Value
Hi,
I need a quick solution as to how I can dynamically call an API based on my filtered values.
For example, if I have a column Country and I am selecting only France in the filtered option or dropdown visualisation option, I want to hit an API that retreives details of the only France and displays the table.
This API requires a country to be a mandatory parameter, so how can I pass a filtered value as an API parameter and run the API to retrieve necessary details?
Please help, have been stuck with this for sometime. :// Mic
1 Reply
Hi. Power Bi won't be sending API requests each time you click on a filter. The idea of power bi is importing all data you can, transform and model, finally use it.
The way to go would be listing all the posible filters you need. Run the API for each one of those at the PowerQuery editor. Concat the rows and import all results.
Something like this: https://blog.ladataweb.com.ar/post/188215249200/powerquery-web-content-por-fila
Good practice for requests (apply to help the engine understand the source): https://blog.ladataweb.com.ar/post/630597294839955456/powerquery-buena-práctica-para-un-web-request
Then you can just build your dashboard and add a filter by country that will filter all the data loaded.
I hope that make sense
