Forum Discussion
Passing filter to the embedded URL
I came accross many articles talking about this but I didn't find the right asnwer to this.
I want to pass a filter like cityname = "Aamman" to the URL as a query parameter, please let me know first if this is doable and if yes, what is the work around to make it work. And if it didn't work with embedded URL, how can I make it work on the cloud service itself, I am on the free plan. Please consider me naive so take me step by step to understand and implement!
6 Replies
Hi hjameelq,
Based on my research, we are not able to pass filter parameter in the URL which created by "Publish to web" feature. But we can pass filter in Power BI service report URL. For example, the report URL like below:
https://msit.powerbi.com/groups/me/reports/fb23cd82-3485-4be7-b53f-df364491f26e/ReportSection
You can pass filter in the URL like below:
https://msit.powerbi.com/groups/me/reports/fb23cd82-3485-4be7-b53f-df364491f26e/ReportSection?filter=DimEmployee%252FGender%20eq%20'M'
Best Regards,
Qiuyun YuWell in the service, we can use the report filter feature instead of using query string to pass parameters. I hope if this fesature will be enabled in the future so we can use the published to web report effectively.
Hopefully soon!
Thanks, -Hanna
Hi hjameelq,
Yes, both in Power BI service and Power BI desktop, we can use Report / Page / Visual level filter. The method pass parameters in report URL will apply in Report level filter.
If you want to get the feature to pass parameter in embedded URL get from publish to web, you can submit a feature request in Power BI Ideas forum.
Best Regards,
Qiuyun Yu
