Power BI URL filter does not working Browser (Agent Code) but working for other filter (Customer

[Mukul227]

Hi Team,

I am facing issue filtering the report when used as below: it is not filtering as expected.

manually we are able to make it filtered but not using below URL.

https://app.powerbi.com/reportEmbed?reportId=f7a163f6-170f-4703-9c9b-84696616eda1&pageName=ReportSec... Code eq 'ABDULSA'

but for same report and page name I am able to filter with another field

https://app.powerbi.com/reportEmbed?reportId=f7a163f6-170f-4703-9c9b-84696616eda1&pageName=ReportSec... eq 'CEVA'

Atttached is SS. - see below for Customer eq 'CEVA' works when given above URL in browser

When I give this URL , it is not filtering and no selection update on right side filter option automatcly

https://app.powerbi.com/reportEmbed?reportId=f7a163f6-170f-4703-9c9b-84696616eda1&pageName=ReportSec... Code eq 'ABDULSA'

what could be issue.

[gregst]

Hello,

If you have a space in the name of a column replace it, in the url, with the code _x0020_ 

Shipment_Level/Agent Code becomes Shipment_Level/Agent_x0020_Code

Avoiding to change all the names of your columns with a space.

[Mukul227]

Thanks , it works , i asked my power BI team to remove space between coloumn name 'AgentCode' , I am able to filter via URL's

Thanks for your answer

[v-binbinyu-msft · Accepted solution]

Hi @Mukul227 ,

Firstly, ensure that the URL is correctly encoded. URL parameters must be properly encoded to be recognized by Power BI. For example, spaces should be encoded as '%20'. Incorrect encoding can lead to the filter not being applied as expected.

Given that filtering works with one field but not the other, it's also possible that there might be an issue with how the field is recognized or with the data itself. Here are a couple of steps to troubleshoot and resolve the issue:

1. Check Field Name and Data Type: Verify that the field name 'Code' is correct and matches exactly with the field name in your dataset, including case sensitivity. Also, confirm that the data type of the 'Code' field is compatible with the filter you're applying (e.g., text).

2. URL Encoding: Ensure that the filter part of your URL is correctly encoded.

3. Special Characters: If your field values contain special characters, they need to be encoded in the URL. For example, spaces are '%20', and the forward slash '/' is '%2F'.

For more details, you could read related document: Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.