Databricks.Query not working

[YahyaN]

Hello,

We get this error when using Databricks.Query :

We created a function :

And we call this function:

Thnks in advance

[v-yinliw-msft]

Hi @YahyaN ,

Did you use the ODBC connector? If so, you can click on the SSL button at the bottom right and enable. Checking "Use Trusted store" and unchecking "Check Certificate Revocation".

Or you can check the name of tables.

You can refer these documentations:

JDBC\ODBC connection to Azure Dataricks fails - Microsoft Q&A

Using a resource path for Power Query connectors - Power Query | Microsoft Learn

Hope these help you.

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[YahyaN]

Hello,
Thanks for your response.
We use Azure Databricks connector :

Best regards,