Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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...
Hi @pbiuser1234 ,
Here is an example which is mentioned in the document @d_gosbell provided:
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.
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.
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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
5 | |
3 | |
3 | |
2 |
User | Count |
---|---|
12 | |
9 | |
7 | |
2 | |
2 |