topic Re: Query string filters using table names with spaces in Developer

Query string filters using table names with spaces

idof — Mon, 06 Mar 2017 21:07:52 GMT

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.

Re: Query string filters using table names with spaces

Eric_Zhang — Wed, 08 Mar 2017 10:12:44 GMT

@idof

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?

Re: Query string filters using table names with spaces

idof — Wed, 08 Mar 2017 10:34:03 GMT

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?

Re: Query string filters using table names with spaces

Eric_Zhang — Mon, 13 Mar 2017 05:15:02 GMT

@idof

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?

Re: Query string filters using table names with spaces

idof — Tue, 14 Mar 2017 18:34:38 GMT

I clicked the ellipsis next to the dataset and renamed it. However, when I click it to create a report, the name of the table remains with spaces. It seems the rename is only for display purposes.

Re: Query string filters using table names with spaces

FGutiyama — Fri, 04 Jan 2019 11:49:29 GMT

PowerBI leverages OData syntax, so try to replace the space by _x0020_

Re: Query string filters using table names with spaces

jakeg — Fri, 20 Mar 2020 17:13:43 GMT

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'

Re: Query string filters using table names with spaces

jakeg — Fri, 20 Mar 2020 17:20:19 GMT

Fixed. Just drop the '

Organization/Organization_x0020_ID eq 12345

Re: Query string filters using table names with spaces

Anonymous — Tue, 18 Aug 2020 09:53:11 GMT

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 .

😞

Re: Query string filters using table names with spaces

Anonymous — Tue, 18 Aug 2020 10:33:17 GMT

I had extra spaces..removing them now it works with _x0020_ also in table name!!!

Thanks a lot!

Re: Query string filters using table names with spaces

IvanBll — Sun, 30 Jul 2023 22:23:13 GMT

God bless you! 🙂