Azure Databricks error when using DirectQuery

[AN_Support]

Hi, 

I need to connect to Azure Databricks using DirectQuery. 

In Power Query Editor everything looks fine, data are being previewed. 

But after applying them, there were two errors. 

First: 

I used the advice from this blog page : How to solve OLE DB or ODBC errors in PowerBI - CloudFronts

And then, the error looks like this.

Second:

So I read here and there that Azure Databricks has problems with DirectQuery. But also that there were some updates in this and now it should work. 

So...what can be the cause of the error?

Thanks in advance!

[AN_Support]

Anyone can help me with understanding the problem?

[Idrissshatila]

Hello @AN_Support ,

Check this article, it will help solve your problem https://www.linkedin.com/pulse/query-folding-azure-databricks-tushar-desai/

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[AN_Support]

Hi @Idrissshatila , thanks, but I've already done it, and it does not help. 

EDIT: I've redo the steps trying to do it as in the link you posted and I am receiving the first error: