power bi support spark directquery on HDP HortonWorks

[ururu]

Since recently PoweBI is support spark "Direct Query" connection.

Could anyone connect to spark in kerberized HDP cluster?

In my case i have tried many different ways, but without success.

My connection string is Server - spark thrift service fqdn and port, Protocol - Standard, Mode - DirectQuery

In next dialog box contain my ActiveDirectory login and password.

But connection is not success:

Details: "ODBC: ERROR [28000] [Microsoft][ThriftExtension] (2) Error occured during authentication."

[ururu · Accepted solution]

For kerberos connection needs to click on tab "windows" and type kerberos parameters

What funny i thought this  is just string, because default tab was "Username/Password"

After this right windows realm,  connection was success.

[open-insights]

@ururu  I thried same steps to connect but getting error "ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1110) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct and confirm if SSL should be enabled for the connection." Can any one help. Thanks in advance!

[v-jiascu-msft]

Thanks for sharing, @ururu.

Best Regards,
Dale