Dynamic Parameter Not Working

[erisant]

At the end of the URL I appended the encoded parameter: %3Ffilter%3Dvtrackntrace%2FCust%20eq%20%271%2ABC%27. It didn't filter by the parameter passed. However, it works after a report page is loaded (unfiltered), and I manually paste it at the end of the URL ?filter=vtrackntrace/Cust eq '1*ABC'. I would like to get the encoded parameter  %3Ffilter%3Dvtrackntrace%2FCust%20eq%20%271%2ABC%27 to work. What am I missing here?

[Anonymous]

Hi @erisant ,

I have a test on my side: 

?filter=vtrackntrace/Cust eq '1*ABC'

It filters the report correctly:

So

1. Please check if there any spaces in your Table / Column Name

2. Please notice that Table and Column names are case-sensitive, value isn't.

3. Uses other browsers to have a try again.

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

[erisant · Accepted solution]

I got it to worked. 

rs:Embed=true&filter=vtrackntrace/Cust eq '1*ABC'

[erisant]

I followed this help article, but it didn't work for me somehow. It is what I wanted to accomplish. The entire URL has to be encoded.

vtrackntrace is my table name
Cust is the field
eq '1*ABC'

I want it filtered by Cust eq '1*ABC'

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

[Anonymous]

Your code should look like this:

• 
  URL?filter="&NameOfParameter

And if there is more after the parameter, it should be surrounded by quotes, like &"TheRest".

--Nate