Forum Discussion
Expression.Error: We cannot convert a value of type Function to type List.
Hi All, Iam facing below error in Power BI while trying to apply custom sql query to the imported data from the azure databricks, I can able to apply custom sql to the new report in power bi fr...
Hello SBC,
I understand that you were following the Microsoft documentation - https://docs.microsoft.com/en-us/azure/databricks/integrations/bi/power-bi#using-a-custom-sql-query
We were solving the same issue in our team and we found out that it was caused by "Navigation" step left in the Query after switch from Databricks.Catalogs to Databricks.Query.
Just remove the Navigation step and it will work as advertized in the Microsoft docs.
Hope this helps