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?filter=table/column eq 'value'), but when I try to use it for the Azure Audit Logs dataset, it doesn't work.
I read somewhere that table names cannot have spaces, unfortunatelly, the name I get when I add the service has spaces in it.
I tried renaming the dataset, but the table name that shows in the report editor doesn't change, and still has spaces.
What is the correct way to use query string filters in this case?
Thanks,
Ido.
10 Replies
- 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
God bless you! 🙂
The space does stop the filter from working based on my test. Per my experience, appending a filter querystring is very limited. You can the same thing by applying a report-level filter. May I know why filter in url is prefered?
I want to create something like this:
1. Create an alert for a value
2. Use Microsoft FLOW to send an email when this value reached a threshold
3. In the email, include a URL to a different report, with a filter in the URL that matches the threshold value (greater than)
Is there an alternative on how to pass dynamic parameters to reports? without needing to manually filtering it?
I'm afraid there's no way then. By the way, in your original post, you said that renaming a table doesn't work, what is the exactly scenario?
