Forum Discussion
Dynamically Change the data source parameter
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
Hi HarshaK49 Binding parameter option is available for Direct Query. Read this article:
Desktop dynamic m query parametersIf 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 HafizHi 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 CommunityBest regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
Hi HarshaK49 Binding parameter option is available for Direct Query. Read this article:
Desktop dynamic m query parametersIf 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 HafizHi 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 CommunityBest regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly