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

987e92c5 31f4-47d9-b2b5-9b4fd9d97a96 on 05 Jul 2020 23:05:22

RE: URL filter report field that has a space

We have been careful to make the table and column names user friendly and thus have spaces. This is a huge limitation for us.

Greg Galloway's profile image Profile Picture

9fd4b53f 13bd-42c5-85b2-cf17bd795e2d on 05 Jul 2020 22:49:27

RE: URL filter report field that has a space

Bump. We really need this, guys. We have large datasets and we can't afford to create new filter columns alongside user-friendly columns.

Greg Galloway's profile image Profile Picture

a1a072ec 290b-43f4-ac03-0fcee7898cae on 05 Jul 2020 22:45:59

RE: URL filter report field that has a space

I hit the underscores problem too, and it cost a lot of time with a support person over Yammer until he identified that this was the issue.

Greg Galloway's profile image Profile Picture

f7775943 3141-45e2-bdf9-c984c936740f on 05 Jul 2020 22:43:54

RE: URL filter report field that has a space

There is also an undocumented limit that this does not work if the table name starts with an underscore. I think there may also be a problem if the column name has underscores.

Greg Galloway's profile image Profile Picture

ec53b15d 2b57-4694-a9ce-5993199527b0 on 05 Jul 2020 22:37:26

RE: URL filter report field that has a space

Can we Have common Date filter That Can Use to filter date related data for all chart

Greg Galloway's profile image Profile Picture

e9f2f188 3cbd-4469-83bd-d5ca703dda67 on 05 Jul 2020 22:29:00

RE: URL filter report field that has a space

I am also looking for similar solution, however if you have implemented the url parameter (without space in names) then can you please share.
It will be a great help to me. Thanks

Greg Galloway's profile image Profile Picture

3b994b3a 3db6-4f3a-addc-55830877d465 on 05 Jul 2020 22:25:45

RE: URL filter report field that has a space

To be able to provide view of the data specifically looking at the part of the organisation the end user is interested in without having to manually click on filters or slicers is really important for us. The URL might have been a way around this, why can't it handle spaces? This should be really easy to fix. We can't change our model as it is SSAS and loads of other reports are already using it.