Forum Discussion
Query string filters using table names with spaces
I'm using Power BI with the web-based report editor, to show Azure Audit Logs. I managed to use query string filters for my other reports (app.powerbi.com/groups/me/reports/guid/reportsection?fil...
PowerBI leverages OData syntax, so try to replace the space by _x0020_
Thank you!! This was a big sticking point for me and really helped!
I'm also stuck on the values filtering by a whole number (it works if its text, but the number... ) Any ideas on how to solve that?Organization/Organization_x0020_ID eq '12345'
Fixed. Just drop the '
Organization/Organization_x0020_ID eq 12345
Hi. You showed an example of column name with spaces in column name but does it work with spaces in table name?
eg:
my table name is "Cliente Storico Segmentazione"
my column name is "Segmentazione"
but Cliente_x0020_Storico_x0020_Segmentazione/Segmentazione doesn't seem to work .
😞
I had extra spaces..removing them now it works with _x0020_ also in table name!!!
Thanks a lot!
God bless you! 🙂
