Add filter to URL by a uniqueidentifier field type

[pbiuser1234]

Hello 

I've tried to add a filter to a report url for a field type uniqueidentifier like this:

?filter=[table name]/[field name] eq '[uniqueidentifier  value]' ,but unfortunately it doesn't work.

Is there any other way to filter a url?

Or alternatively is there another way to pass a parameter value to a report parameter on a report server?

Thank you

[Icey]

Hi @pbiuser1234 ,

Here is an example which is mentioned in the document @d_gosbell provided:

• Power BI Report Server also supports the ability to specify additional filters using the “filter” URL parameter. Here's an example of what the URL might look like in Power BI Report Server: https://reportserver/reports/powerbi/Store Sales?rs:Embed=true&filter= Store/Territory eq 'NC' and Store/Chain eq 'Fashions Direct'

Best Regards,

Icey

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

[d_gosbell · Accepted solution]

I just did a test putting some random guids in a table and this worked fine. There is no special GUID data type in Power BI so these are just strings.

The following URL produces the output below for me.

http://localhost/reports/powerbi/Guid%20Filter?filter=Test/Guid%20eq%20%277e833f81-bc28-42e6-a6ca-44...

Does your table or column name contain any spaces or special characters? if so make sure you are encoding them correctly. see https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#special-characters-i...