Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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-...&filter='OAT Database List'/Title eq 'AI Driller'
Solved! Go to Solution.
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,
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,
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |