Forum Discussion

anushav's avatar
anushav
New Member
4 years ago

Passing dynamic values to an API query string using slicers

Hi,

 We have a Power BI report which fetches the data by calling an API. The API URL accepts a few parameters and returns the result set. The ask is to allow users to dynamically set the values of these query parameters in the API using slicers. Is this possible in Power BI. We tried using parameters but unfortunately, parameters are not exposed to end users

 

Example

URL - http://xyz.azurecontainer.io/test?band=b1&num_employees=50

The values for band and num_employees must come from slicers at run time and call the API which returns a list of employee numbers matching these params.