Skip to main content

Power BI

Needs Votes

URL filter report field that has a space

Vote (98) Share
Greg Galloway's profile image

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 (30)
Greg Galloway's profile image Profile Picture

Michael Lowden on 27 Apr 2022 17:34:45

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'

Greg Galloway's profile image Profile Picture

Murtaja Bohra on 08 Jan 2022 00:27:19

RE: URL filter report field that has a space

Is there an ETA on this feature?

Greg Galloway's profile image Profile Picture

Calvin Francart on 05 Nov 2020 13:53:00

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

Greg Galloway's profile image Profile Picture

Power BI User on 05 Jul 2020 23:49:44

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

Greg Galloway's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:49:06

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)

Greg Galloway's profile image Profile Picture

Power BI User on 05 Jul 2020 23:40:00

RE: URL filter report field that has a space

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

Greg Galloway's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:39:47

RE: URL filter report field that has a space

When will this be fixed?

Greg Galloway's profile image Profile Picture

F Gutiyama on 05 Jul 2020 23:38:14

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.

Greg Galloway's profile image Profile Picture

Sankalp Jain on 05 Jul 2020 23:26:44

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.

Greg Galloway's profile image Profile Picture

Power BI User on 05 Jul 2020 23:26:23

RE: URL filter report field that has a space

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