Dynamically Change the data source parameter

[HarshaK49]

Hi,

My data source is an API endpoint (example: http://pie_chart_powerbi/company1 ), where "company1" is a parameter that needs to be changed dynamically (i.e. company2, company3....companyN). I want to achieve this through an embedded URL in Power BI by passing the parameter.

Binding the fields to the parameter option is not available in the properties of the model view.

Please provide guidance or examples on how to pass this parameter dynamically through an embedded URL to ensure seamless integration with my reports.

Thanks

[shafiz_p · Accepted solution]

Hi @HarshaK49  Binding parameter option is available for Direct Query. Read this article:

Desktop dynamic m query parameters 

If you want to change parameter for API request from report page, you can do this using Edit parameter. See the earlier post here:

Power Bi change value of the parameters used in web request api 

Hope this helps!!

If this solved your problem, Please accept it as a solution!!

Best Regards,
Shahariar Hafiz

[Anonymous · Accepted solution]

Hi @HarshaK49 ，
Thanks for shafiz_p reply.
You can also try using query string parameters. With query string parameters, the model author can let the report viewer set the value of the query parameter using filters or slicers
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
Solved: Passing Parameters Dynamically in Power BI Embedde... - Microsoft Fabric Community

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[shafiz_p · Accepted solution]

Hi @HarshaK49  Binding parameter option is available for Direct Query. Read this article:

Desktop dynamic m query parameters 

If you want to change parameter for API request from report page, you can do this using Edit parameter. See the earlier post here:

Power Bi change value of the parameters used in web request api 

Hope this helps!!

If this solved your problem, Please accept it as a solution!!

Best Regards,
Shahariar Hafiz