Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Mukul227
Regular Visitor

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/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

Mukul227_0-1708942777211.jpeg

 

 

 

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'

Mukul227_1-1708942789388.jpeg

 

what could be issue.

1 ACCEPTED SOLUTION
v-binbinyu-msft
Community Support
Community Support

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.

View solution in original post

3 REPLIES 3
gregst
Frequent Visitor

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
Regular Visitor

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
Community Support
Community Support

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors