Forum Discussion
adding a filter to an URL to a Power BI Service, not working
Hey all,
A bit frustrated trying to use the filter at the end of the URL on a Power BI report hosted on a workspace.
The Table in the report is the result of a SQL query that is imported into the report. When I add the filter following the "correct syntax" URL?filter=<table>/<field> eq '<value>' the URL goes back to its original state ignoring the filter.
There are of posts with similar issues but I have not found the appropriate solution. Can anybody give me some hints?
Thanks
2 Replies
Hi ncastillor ,
You may check the Considerations and troubleshooting about URL filters.
There are a couple of things to be aware of when using the query string parameters.
- When using the in operator, the values to the right of in must be a comma-separated list enclosed in parentheses.
- 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' - Report URL filters have a 10-expression limit (10 filters connected by AND).
- The long data type is (2^53-1) due to JavaScript limitations.
- Power BI doesn't limit the number of characters in URL query strings. Different browsers have different length restrictions.
URL filters are supported in some embedding scenarios and not in others.
- Embedding a report in a secure portal or website is supported.
- URL filters are supported in Power BI Embedded. See Power BI Embedded advanced URL filtering capabilities for details.
- Query string filtering doesn't work with Publish to web or Export to PDF.
- Embed with report web part in SharePoint Online doesn't support URL filters.
- Teams doesn't allow specifying a URL.
Best Regards,
Jay
Hi Jay,
Thank you for responding but it appears not helping me much with the issue.
cheers
