Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |