Forum Discussion
cdebadri
2 years agoNew Member
PowerBI report filtering when table or column name has underscores in names
Hi,
I'm try to filter a powerbi report from report server with url parameters. My tables and columns have underscore in names like "table_name" and "column_name". When I try to filter the report using url:
https://server/report?filter=table_name/column_name eq 'Item'
I even tried by removing the underscores from names but to no effect. I checked the docs but nothing is said about underscore being considered a special character.
1 Reply
- lbendlinSuper User
I even tried by removing the underscores from names but to no effect.That might point to a spelling mismatch. You need to use the exact spelling for table and column names.
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
Underscore is %5F which needs to be encoded as _x005f_