Forum Discussion
Power BI Report URL Parameter Filters not working
I've tried to filter reports both in my workspace and other workspaces using URL parameters but the content does not get filtered.
This is what I'm doing (&filter='OAT Database List'/Title eq 'AI Driller' is the part I've added)
https://app.powerbi.com/groups/647b465e-a833-4578-9bdf-7e9a0201037d/reports/1c63d825-2554-4e38-92a3-ad0bef3d1153/ReportSectioncde4a321d10228707596?experience=power-bi&filter='OAT Database List'/Title eq 'AI Driller'
Hi there aar1
For Power BI URL filters, special characters (including spaces) in table or column names need to be encoded appropriately. See here:
For example, spaces in table or column names need to be encoded as:
_x0020_Your URL should end up looking something like:
https://app.powerbi.com/groups/647b465e-a833-4578-9bdf-7e9a0201037d/reports/1c63d825-2554-4e38-92a3-ad0bef3d1153/ReportSectioncde4a321d10228707596?experience=power-bi&filter=OAT_x0020_Database_x0020_List/Title eq 'AI Driller'Spaces in values (such as 'AI Driller') can be left as-is in my experience, but are automatically translated to %20 after navigating to the URL.
Regards,
1 Reply
- OwenAuger
Super User
Hi there aar1
For Power BI URL filters, special characters (including spaces) in table or column names need to be encoded appropriately. See here:
For example, spaces in table or column names need to be encoded as:
_x0020_Your URL should end up looking something like:
https://app.powerbi.com/groups/647b465e-a833-4578-9bdf-7e9a0201037d/reports/1c63d825-2554-4e38-92a3-ad0bef3d1153/ReportSectioncde4a321d10228707596?experience=power-bi&filter=OAT_x0020_Database_x0020_List/Title eq 'AI Driller'Spaces in values (such as 'AI Driller') can be left as-is in my experience, but are automatically translated to %20 after navigating to the URL.
Regards,