Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone,
I'm trying to filter a report on PBI Service using url query parameters.
This is the original URL - https://app.powerbi.com/groups/me/reports/06cfe45f-46f1-4bb5-96ad-353ab96e142d/ReportSection?experie...
(I noticed that extra 'experience=power-bi' is added automatically to everything recently)
Table Name - ADGroups
Column Name - Group Name
The URL I'm trying to pass - https://app.powerbi.com/groups/me/reports/06cfe45f-46f1-4bb5-96ad-353ab96e142d/ReportSection?experie... Name eq 'MSFTProjPortfolioManager'
But nothing happens. The report loads without anything filtered.
I also tried https://app.powerbi.com/groups/me/reports/06cfe45f-46f1-4bb5-96ad-353ab96e142d/ReportSection?experie... Name eq 'MSFTProjPortfolioManager' but Power BI Service just ignored that. I also tried removing the experience =power-bi part but that just got added back when the page loaded and it still did not work.
Any idea what I'm missing out?
Solved! Go to Solution.
Hi , @reshmasara
According to your description, you are filtering a report using query string parameters in the URL.
According to your url , i think this may cause by the space in your column name.
The url format is like this:
?filter=Store/Territory eq 'NC'
So for your need , you can try to use the :
https://app.powerbi.com/groups/me/reports/06cfe45f-46f1-4bb5-96ad-353ab96e142d/ReportSection?experie..._x0020_Name eq 'MSFTProjPortfolioManager'
For more information, you can refer to :
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , @reshmasara
According to your description, you are filtering a report using query string parameters in the URL.
According to your url , i think this may cause by the space in your column name.
The url format is like this:
?filter=Store/Territory eq 'NC'
So for your need , you can try to use the :
https://app.powerbi.com/groups/me/reports/06cfe45f-46f1-4bb5-96ad-353ab96e142d/ReportSection?experie..._x0020_Name eq 'MSFTProjPortfolioManager'
For more information, you can refer to :
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
That worked! Thank you!