Forum Discussion
Filtering Issue PowerBI Report with Metric Views
Thank you for your time and support. The suggested solution did not resolve the issue in our case. However, after modifying the query on the Databricks side, the problem was resolved and the visuals are now working as expected.
Appreciate the help.
Regards,
Mahesh
Please copy and paste the text of the error into the question. Cannot see the image of the error msg.
Hi Thomaslleblanc ,
Thanks for your time and Please find the error message.
OLE DB or ODBC error: [DataSource.Error] ADBC: An unexpected error occurred while fetching results. 'One or more errors occurred.: (1)
[MISSING_ATTRIBUTES.RESOLVED_ATTRIBUTE_MISSING_FROM_INPUT] Resolved attribute(s) "Year Month" missing from "Monthly Redemption", "MonthlyAUM", "fund_dim", "share_class_dim", "advisor_dim", "org_dim", "territory_dim" in operator !Aggregate [named_struct(col1, max(YearMonth#13456)) AS _internal_window_measure_Current Month Redemption#13469, named_struct(col1, max(YearMonth#13456)) AS _internal_window_measure_Prior 11M Redemptions#13470, named_struct(col1, max(YearMonth#13456)) AS _internal_window_measure_Current Month AUM#13473, named_struct(col1, max(YearMonth#13456)) AS _internal_window_measure_Prior 12M AUM#13474, named_struct(col1, max(YearMonth#13456)) AS _internal_window_measure_Current Month Redemption#13469, named_struct(col1, max(Year Month#13456)) AS _internal_window_measure_Prior 11M Redemptions#13470, named_struct(col1, max(YearMonth#13456)) AS _internal_window_measure_Current Month AUM#13473, named_struct(col1, max(YearMonth#13456)) AS _internal_window_measure_Prior 12M AUM#13474]. SQLSTATE: 42704; line 1 pos 69".Regards,
Mahesh
The core issue is your query references a column called “Year Month” (with a space) that does NOT exist in any of the listed tables, while the engine does find a column named YearMonth (no space).