Expression.Error: We cannot convert a value of type Function to type List.

[SBC]

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 from  azure databricks but not able to apply custom sql  in the exsiting report below error iam facing.

Thanks.

[petruf]

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

[v-luwang-msft]

hI @SBC ,

Since I don't have your specific environment and pbix file, I can only search the web for you with similar questions：

Similar questions refer:

https://forum.enterprisedna.co/t/replacing-substitute-from-excel/5493 

https://community.powerbi.com/t5/Power-Query/Expression-Error-We-cannot-convert-the-value-to-type-Li... 

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

Best Regards

Lucien

[amitchandak]

@SBC , Are you trying to change the source ?

This error is related to data type difference usually

Can you share more details

refer if needed

Change Connection from One source type to another Source Type and use existing steps: https://youtu.be/nwYJgG2hmd0