Filter page using query parameter

[dixus]

Hello,

i've found this post that shows how to filter a report using query parameters.

https://app.powerbi.com/groups/me/reports/8d6e...?filter=Store/TerritoryChain eq 'NC'

Unfortunately, I can't get it to work. I assume that it should also work on hidden pages (drillthrough destinations)?
In addition, my table name does not consist of only one word. I have tried it in several ways, but the filter is never applied:

https://app.powerbi.com/groups/34...b2/reports/1d...64f/ReportSection76ad...0b68c?filter='My Table'/ColumId eq 'b5aa0e97-5c8b-4b10-92a7-6f8cfe4f01e2'

What am i doing wrong here? Is there a special syntax or are only "single word"-named tables possible?

Second Question to that topic: Is there away to clear all other page filters using a query string parameter too?

Kind regards,

Holger

[Greg_Deckler]

Have you tried %20 in your table name, so 'My%20Table'?

[dixus]

---

@Greg_Deckler wrote:

Have you tried %20 in your table name, so 'My%20Table'?

---

yes.. also the browser also url encodes spaces automatically.. 

[Greg_Deckler · Accepted solution]

I can't find a way to get that syntax to work with a space in the table name. Can you just rename your table?

[dixus]

---

@Greg_Deckler wrote:

I can't find a way to get that syntax to work with a space in the table name. Can you just rename your table?

---

Yes, that is what I have done now, but was not my desired solution.

If the multiword tables in the service are valid, it should be documented that this kind of table name syntax is not supported for the query paramater.

Thanks for your answers Greg,

Holger