Forum Discussion
URL Filtering not working
Hi Kushagra
A couple of suggestions that may help:
- Does your table Sheet1 contain the column Sheet1[name]?
Just checking, since the column used in the visual appears to be name column.
If it doesn't exist, you could create a name column and set it equal to name column. - Column names used in URL parameter filters only work if they don't contain spaces.
- In my testing, filters will not work if table names are enclosed in single quotes, so remove the single quotes around Sheet1.
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'- Does your table Sheet1 contain the column Sheet1[name]?
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 Anonymous
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