Forum Discussion
Using a URL to filter to specific data
Hi,
This URL will filter my data in Chrome as needed to only see the data desired:
https://app.powerbi.com/groups/0e0c3979-702e-4398-b129-27d82939aa18/reports/58025639-1e3c-4a00-8cef-b759011f4508/ReportSection?filter=vwRevitDocumentSession/ProjectStudioCode eq 'SEA51' and vwRevitDocumentSession/ProjectNumber eq '101805.00'
I need to do the same thing however I cannot seem to get it to work because of special characters. Here is the URL without special characters:
https://app.powerbi.com/groups/0e0c3979-702e-4398-b129-27d82939aa18/reports/58025639-1e3c-4a00-8cef-b759011f4508/ReportSection?filter=vwRevitDocumentSession/ProjectStudioCode eq 'NONE' and vwRevitDocumentSession/RevitFilePath eq 'BIM 360:\Project Village'
I've been trying to use this info but cannot seem to get the filtering to work:
https://docs.microsoft.com/en-us/power-bi/service-url-filters
I've tried various syntax similar to below:
https://app.powerbi.com/groups/0e0c3979-702e-4398-b129-27d82939aa18/reports/58025639-1e3c-4a00-8cef-b759011f4508/ReportSection?filter=vwRevitDocumentSession/ProjectStudioCode eq 'NONE' and vwRevitDocumentSession/RevitFilePath eq 'BIM_x0020_360_0x3a__0x5c_Project_x0020_Village'
...also thought maybe the '360' was causing the problem, tried this:
https://app.powerbi.com/groups/0e0c3979-702e-4398-b129-27d82939aa18/reports/58025639-1e3c-4a00-8cef-b759011f4508/ReportSection?filter=vwRevitDocumentSession/ProjectStudioCode eq 'NONE' and vwRevitDocumentSession/RevitFilePath eq 'BIM_x0020__%330__%360__%300__0x3a__0x5c_Project_x0020_Village'
Filtering on 'NONE' works but not the 'BIM 360:\Project Village'
Any ideas?
Thanks,
Dan
3 Replies
- v-cherch-msft
Microsoft Employee
Hi dtartaglia
Please check if below articles could help.
https://powerbi.microsoft.com/fr-fr/blog/filter-a-report-with-a-url-query-string-parameter/
https://www.dutchdatadude.com/passing-filters-to-power-bi-reports-using-the-url-query-string/
Regards,
- dtartaglia
Resolver I
Got it working. I renamed a field which caused some grief. Once I renamed it back the original URL witout unicode worked.
Thanks,
Dan
- v-cherch-msft
Microsoft Employee
Hi dtartaglia
Glad to hear you've solved it, please accept your reply as solution, that way, other community members will easily find the solution when they get same issue.
Regards,