Forum Discussion

Mukul227's avatar
Mukul227
Regular Visitor
2 years ago
Solved

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

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/re...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.