URL Filter

[Gaurav51478]

Hi EveryOne!

Need help!

I am trying to create a URL Filter with the below code but it seems due to Semicolon(:) unique character It is not working

filter=PPM_DIM_XYZ/Svc L2: Offer Type in ('ABC')

Table Name = PPM_DIM_XYZ

Column Name= Svc L2: Offer Type

Value= ABC

I have tried using %3A as an escape character but i.e. also not working, Recommended in Percent-encoding - Wikipedia

[v-yanjiang-msft · Accepted solution]

Hi @Gaurav51478 ,

By my test, this code can work fine:

?filter=PPM_DIM_XYZ/Svc_x0020_L2_x003A__x0020_Offer_x0020_Type eq 'ABC'

Here, I replace space with _x0020_ and replace : with _x003A_

Reference: URL escape codes

Best Regards,
Community Support Team _ kalyj

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

[ibarrau]

Hi! you don't need to only escape, you also need the unicode of the symbol. Escaping "_x[unicode]".

You can read more about that here: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#special-characters-i...

You should also do that for spaces.

I hope that helps,