Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ururu
New Member

power bi support spark directquery on HDP HortonWorks

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."Capture4.PNG

 

Capture5.PNG

 

Capture6.PNG

 

1 ACCEPTED SOLUTION
ururu
New Member

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"

Capture7.PNG

After this right windows realm,  connection was success.

View solution in original post

3 REPLIES 3
ururu
New Member

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"

Capture7.PNG

After this right windows realm,  connection was success.

@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!

Thanks for sharing, @ururu.

 

 

Best Regards,
Dale

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.