Greg Galloway on 15 May 2016 10:11:03
There is currently a limitation that you can't URL parameter filter on a field or a table with a space in the name. Please fix this.
http://community.powerbi.com/t5/Service/URL-parameter-to-filter-report-on-a-field-with-spaces/m-p/34891#M8603
- Comments (31)
RE: URL filter report field that has a space
Good information, thankssehackear.top
RE: URL filter report field that has a space
OMG!!!!!!! the OData trick totally worked. Now my URL looks funny but it works.old: [baseURL]?$filter=Table Name/Field Name eq 'Some Value'new: [baseURL]?$filter=Table_x0020_Name/Field_x0020_Name eq 'Some Value'
RE: URL filter report field that has a space
Is there an ETA on this feature?
RE: URL filter report field that has a space
The fact that it's actually in their own documentation that spaces are acceptable when part of a string makes it that much more irritating. This is from the online doc https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#query-string-parameter-syntax-for-filtering
"Field types
Field type can be a number, datetime, or string and the type used must match the type set in the dataset. For example, specifying a table column of type "string" won't work if you're looking for a datetime or numeric value in a dataset column set as a date, such as Table/StringColumn eq 1.
Strings must be enclosed with single quotes, as in 'manager name'."
RE: URL filter report field that has a space
We want to use user friendly naming but can't if we also want to have filtering, huge miss
RE: URL filter report field that has a space
i want to filter by a link but most of our tables are with space
it is very complicated to rename the all tables(hundreds)
RE: URL filter report field that has a space
PowerBI leverages OData syntax, so try to replace the space by _x0020_
RE: URL filter report field that has a space
When will this be fixed?
RE: URL filter report field that has a space
This is OData syntax, so try to replace the space by _x0020_
That worked for me.
RE: URL filter report field that has a space
Having spaces in table names and column names is common for semantic layer. That is what semantic layer or PBI data model is about - to provide meaningful names.
This is a limitation while using such scenarios. Please fix.