topic Re: Passing dynamic values to an API query string using slicers in Developer

Passing dynamic values to an API query string using slicers

anushav — Tue, 16 Nov 2021 06:42:06 GMT

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.

Re: Passing dynamic values to an API query string using slicers

Nisha1993 — Thu, 18 Nov 2021 02:37:09 GMT

Hi @anushav

Did you get any solution for this requirement?

Even I have the same requirement.

Can you please let me know if you come across any work around?

Re: Passing dynamic values to an API query string using slicers

V-lianl-msft — Fri, 19 Nov 2021 06:43:09 GMT

You could try using this new feature "Dynamic M Query Parameters"