http://community.powerbi.com/t5/Service/URL-parameter-to-filter-report-on-a-field-with-spaces/m-p/34891#M8603
Comments
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'
Is there an ETA on this feature?
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'."
We want to use user friendly naming but can't if we also want to have filtering, huge miss
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)
PowerBI leverages OData syntax, so try to replace the space by _x0020_
When will this be fixed?
This is OData syntax, so try to replace the space by _x0020_
That worked for me.
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.
We need this asap please ... lack of this is really a showstopper for us.