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 I have tried filtering powerbi report using url filters, but unable to make it filter the published report
{url of report}/ReportSection?filter='Sheet1'/name eq 'Samuel Jack'
Any help is appreaciated. Thanks in advance
Solved! Go to Solution.
Hi @Kushagra
A couple of suggestions that may help:
Putting this together, as long as your table Sheet1 contains the column name, this should work:
{url of report}/ReportSection?filter=Sheet1/name eq 'Samuel Jack'
I am trying to use a URL for Employee Name. Does the limitation for filtering on a URL still have to be a single name without spaces? Or, does anyone have other suggestions to work around this? We have a page with multiple reports/visuals, all relating to the Employee. I'm trying to see if I give the URL to this page, but then just with a specific Employee Name, how to do this.
Thank you for any suggestions.
Hi @cbrsmus195
Yes spaces are allowed in the URL filter parameter.
For example, I published the attached PBIX and this form of URL filters the report correctly:
https://app.powerbi.com/groups/me/reports/XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX/ReportSection?filter=Employee/Name eq 'Will Graham'
The spaces and other punctuation marks within the parameter will be converted with percent-encoding (%20 etc) and can also be entered that way in the first place.
Regards
Hi @Kushagra
A couple of suggestions that may help:
Putting this together, as long as your table Sheet1 contains the column name, this should work:
{url of report}/ReportSection?filter=Sheet1/name eq 'Samuel Jack'
Hi Owen,
I tried using a new report, with correct names of table and columns, but it still wont work. Is this a limitation of PowerBI Pro license for a report that is published?
How my data looks has been shared below for reference -
Visualization view -
Dataset -
After publishing, my url to test this filtering is - {url of the report}/ReportSection?filter=Salary/emp eq 'Jack'
Yet there is no update on the filter (both with and without filter lock on PowerBI desktop)
Hi again @Kushagra
That's odd that it's not working at your end. Have you had any success since your last message?
I have created and published a report essentially identical that in your last post, and the URL filter you posted works as intended. I used an account without a Pro licence and published to My Workspace.
Regards,
Owen
User | Count |
---|---|
50 | |
39 | |
18 | |
14 | |
13 |
User | Count |
---|---|
99 | |
71 | |
29 | |
18 | |
13 |