Forum Discussion

dtartaglia's avatar
dtartaglia
Icon for Resolver I rankResolver I
7 years ago

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