Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.