Announcements
Hi,
Syntax error at position 8 in 'Hi / Hello ne 'N/A - Hello''.
in filter query i have - Hi / Hello ne 'N/A - Hello' .. meaning i want to exclude those rows.
It is because of the "/" in my column?
thanks.
no, it is because of the spaces. Encode these.
@lbendlin How can I encode ?
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
replace each space with _x0020_
@lbendlin need to do for "/" aswell..
but getting an error on
Hi_x0020_x002F_x0020_Hello
_x0020_ is for spaces
so i believe _x002F_ is for "/"
yes, usually "/" is reserved for the separation of table name and column name.
@lbendlin sigh, so should my headers be renamed to exclude the "/" then? this is alot of work.
You are certainly well advised to keep column names simple and free of spaces or special characters.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 427
Vish WR 316
David_MA 260 Super User 2026 Season 1
