Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
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!
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.
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!
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.
User | Count |
---|---|
64 | |
27 | |
25 | |
17 | |
11 |