Using a URL to filter to specific data

[dtartaglia]

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-... '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-... '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-... 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-... '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

[v-cherch-msft]

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]

Hi @v-cherch-msft 

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]

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,