Rest API With User Selected Parameters As Data Source

[ukantkumar]

I am calling Rest API as  Data Source, that Rest API contains 4 to 5 types ID, so I can't put hard code value in the ID. what I want user can select that ID, (it means dynamic ID parameter in that rest API URL)?

[v-yulgu-msft]

Hi @ukantkumar,

You may need to create a report template which allows users to selecte a parameter item to dynamically load data source. However, with this way, users can only change the parameter selection in desktop or under the dataset settings after publishing reports to service. If you share reports with other via service, or embedded, report viewers are not able to change the parameter selection. Actually, parameter is not accessable to them.

For how to pass query parameter to API call, please refer to below links:

Power BI Desktop Query Parameters, Part 1

Parameters for JSON API data - Maintain Query daily

Dynamic connection to Web URL

Best regards,

Yuliana Gu