Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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,
Got it working. I renamed a field which caused some grief. Once I renamed it back the original URL witout unicode worked.
Thanks,
Dan
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,