97
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
STATUS DETAILS
Needs Votes

Comments

G

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'

G

Is there an ETA on this feature?

G

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'."

G

We want to use user friendly naming but can't if we also want to have filtering, huge miss

G

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)

G

PowerBI leverages OData syntax, so try to replace the space by _x0020_

G

When will this be fixed?

G

This is OData syntax, so try to replace the space by _x0020_

That worked for me.

G

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.

G

We need this asap please ... lack of this is really a showstopper for us.