Help with URL Filters (Special Characters?)

[Anonymous]

Hello,

I'm having trouble implementing a url filter and I'm wondering if anyone can help me figure out what I've done wrong.

Here's the url/query parameters:

[url]?filter=SLA_x0020_Query/Bldg._x0020_Region in ('NorAm West', 'NorAm East')

Table: "SLA Query"

Column: "Bldg. Region"

Values: "NorAm West" and "NorAm East"

I replaced the spaces per https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters but that doesn't seem to work as expected. I've tried replacing all the spaces in the url, none of them, some of them. I can't seem to get this to filter appropriately.

What have I done wrong?

[v-xicai]

Hi @Anonymous ,

You may try:

[url]?filter=SLA_0020_Query/Bldg._0020_Region eq 'NorAm West' and SLA_0020_Query/Bldg._0020_Region eq 'NorAm East'

For reference:

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

https://stackoverflow.com/questions/54667067/power-bi-embedded-parameter-space-in-column-name

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for your reply Amy,

I tried your attempt but it did not work. I think the period after Bldg is a problem, so I also tried changing that, no dice. Additionally, I don't think your logical statement returns the desired result (if it worked). I want to include data points from East and West. There are no data points that are both East and West. Perhaps or would work.

Attempt below:

[skolbe]

Did you ever find a resolution? I have a column with a period in the name that I want to use in a URL filter and I'm having trouble with it as well. I don't own the report so I can't change the column name.

[Greg_Deckler]

@Anonymous - Sorry, you are using this where and getting what as an error?

[Anonymous]

Thanks Greg,

My error is a webpage not found: 

My goal is to just to provide a link to a user such that they're sent to a page that has filters pre-applied through the url. One thing that a coworker wondered was whether additional action needed to be taken surrounding bookmarks. The url without any url filters applied is one that directs to a bookmark view of the report. 

[Anonymous]

Problem Unsolved

Here's an additional (unsuccessful) attempt: 

[url]?filter=SLA_x0020_Query/Bldg_x002e__x0020_Region in ('NorAm West', 'NorAm East')