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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Dynamic Filter on Power BI report-ASCII characters in the URL?

 

Hi All,
SSAS Tabular Model- I have a calculated column for Dynamic Power BI report filter(Category-WebURL; data type-text):

 

Hi All,
SSAS Tabular Model- I have a calculated column for Dynamic Power BI report filter(Category-WebURL; data type-text):
="https://app.powerbi.com/groups/69b07d24-da52-4d5d-9e0d-0c8c8d1fe10c/reports/0c3796d5-d474-4c2a-9bd2-eb4bc15e7993/ReportSection?filter=LH_Report_SQL_ObjectsX/SQL_OBJECT_NAME eq '"&[SQL_OBJECT_NAME]&"'"

The purpose of this URL is to pass the table name as a dynamic filter and open up a child report which lists all reports which use the table name passed in the dynamic filter.
If I copy paste a sample row from the calcualted column in a web browser , it works as expected -applies the dynamic filter on the child report
https://app.powerbi.com/groups/69b07d24-da52-4d5d-9e0d-0c8c8d1fe10c/reports/0c3796d5-d474-4c2a-9bd2-eb4bc15e7993/ReportSection?filter=LH_Report_SQL_ObjectsX/SQL_OBJECT_NAME eq 'ACC_LOG_DTL_IX'

However, when I use the dynamic column in the parent report with the URL icon property turned on , the filtering doesn't work-it opens up the child report but does not apply the filter- I see some ASCII characters like %252 when I click the URL icon.
https://app.powerbi.com/groups/69b07d24-da52-4d5d-9e0d-0c8c8d1fe10c/reports/0c3796d5-d474-4c2a-9bd2-eb4bc15e7993/ReportSection?filter=LH_Report_SQL_ObjectsX%252FSQL_OBJECT_NAME%C2%A0eq%C2%A0'ACC_WRKF_MTLDTL_NI'

Just curious if anyone else has seen this issue. This report is critical and I'm looking forward to fix this sooner. Thanks!

 

Just curious if anyone else has seen this issue. This report is critical and I'm looking forward to fix this sooner. Thanks!

8 REPLIES 8
GilbertQ
Super User
Super User

Hi there, those are URL encoded values which has to be used to represent the spaces (%20) and the forward slashes etc.

What I would do is ensure that when the column values are in your report table that they match exactly. And also ensure that you change the data category for your URL to Web URL on your column in Power BI Desktop.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

Thanks for the quick reply. I verified that the column name is right and the data category is set up as WebURL in Tabular  Model. 

It is interesting to note that the URL works and passes the filter if I copy paste the column value from the Tabular model into a web browser. When I click the URL from within the Power BI report, it works partially-it opens the child report but doesn't pass the filter.

I've pasted both the URLS below for comparison

NAME%20eq%20' ACC_WRKF  --works  when pasted from the Tabular model

NAME%C2%A0eq%C2%A0'ACC_WRKF--this is the URL when I click the URL icon in the report

https://app.powerbi.com/groups/69b07d24-da52-4d5d-9e0d-0c8c8d1fe10c/reports/0c3796d5-d474-4c2a-9bd2-eb4bc15e7993/ReportSection?filter=LH_Report_SQL_ObjectsX%252FSQL_OBJECT_NAME%20eq%20'ACC_WRKF_MTLDTL_NI'

https://app.powerbi.com/groups/69b07d24-da52-4d5d-9e0d-0c8c8d1fe10c/reports/0c3796d5-d474-4c2a-9bd2-eb4bc15e7993/ReportSection?filter=LH_Report_SQL_ObjectsX%252FSQL_OBJECT_NAME%C2%A0eq%C2%A0'ACC_WRKF_MTLDTL_NI'

The first one (from the model)  works. The second URL (from the report) works partially.Looks like  %A0-non breaking space needs to be avoided..I would like to see just the %20 in the URL since I just had a space in the formula. Any ideas would be helpful.Thanks!

Hi there

What I would suggest and what I have done in the past is to put in the URL encoding directly into your column. This will allow you to test it and make sure that it works as expected. So that once deployed it will work.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

Thanks for the reply. The issue still persists.The dynamic  link still works in the old report but if I create a new report based on the same dataset and column, it does not work anymore.

="https://app.powerbi.com/groups/69b07d24-da52-4d5d-9e0d-0c8c8d1fe10c/reports/0c3796d5-d474-4c2a-9bd2-eb4bc15e7993/ReportSection?filter=LH_Report_SQL_ObjectsX/SQL_OBJECT_NAME eq '"&[SQL_OBJECT_NAME]&"'"

Hi @Anonymous

 

It would appear that putting in the square brackets is causing it to not work.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

It looks like something might have broken in the new monthly release.. The same dynamic link object with square brackets still works fine in the old table I created last month . If I create a table in  a new   page  in the same report based on the same dynamic link column it breaks. The square brackets does not seem to be an issue based on testing results. Thanks!

Glad I could help out




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

Thanks for the follow-up replies and suggestions. Just to clarify, the issue still exists - the dynamic link opens the child report but doesn't pass the filter. I'll update if I find any fix.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors