cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RR_Analytics Frequent Visitor
Frequent Visitor

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
Super User
Super User

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

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 Datanaut!"
Power BI Blog
RR_Analytics Frequent Visitor
Frequent Visitor

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

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!
Super User
Super User

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

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 Datanaut!"
Power BI Blog
RR_Analytics Frequent Visitor
Frequent Visitor

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

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]&"'"
Super User
Super User

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

Hi @RR_Analytics

 

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 Datanaut!"
Power BI Blog
RR_Analytics Frequent Visitor
Frequent Visitor

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

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!

Super User
Super User

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

Glad I could help out

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
RR_Analytics Frequent Visitor
Frequent Visitor

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

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
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)