Skip to main content

Power BI

New

URL filter report field that has a space

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

a3998d99 1562-47db-8aa2-3888bc34ce78 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

a3309361 99be-ea11-a812-000d3a8ddfb2 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

5ac29d34 8164-4202-91bc-48d2b0d40740 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

a3309361 99be-ea11-a812-000d3a8ddfb2 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

65e9486a aa22-4147-bd18-ae10724509aa 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

09240cf7 7fb8-4846-b2e8-3b3815ea9f48 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

fbd8ddc0 ef72-4828-a889-cd8f8c4d8afb 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.

Greg Galloway's profile image Profile Picture

b816e017 e606-47d5-b8bb-d01bcd0d1f63 on 05 Jul 2020 23:26:22

RE: URL filter report field that has a space

need this functionality

Greg Galloway's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:25:51

RE: URL filter report field that has a space

HUGE need for this.

Greg Galloway's profile image Profile Picture

a02b37f1 59b5-46ce-b4e6-ab0b24bde6d8 on 05 Jul 2020 23:24:26

RE: URL filter report field that has a space

with accents too (for names in french by example)