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)
RE: URL filter report field that has a space
This feature does not work when i) you use spaces in the table name or column name ii) you use underscores in the column name iii) The names are also case sensitive
RE: URL filter report field that has a space
This is so important..
RE: URL filter report field that has a space
How far away is this? A data model will have spaces, I don't see the point of having camel case writing in reports facing humans. This must be a quick fix?
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.
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.
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.
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.
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
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
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.