cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Code84 Frequent Visitor
Frequent Visitor

Problems with connecting against Azure Spark on HDInsight

Hello I am trying out PowerBI together with Azure Spark on HDInsight.

However I am failing with connecting PowerBI with Azure Spark.

 

I only get "We are unable to establish connection, please check connection information."

The connection information is looking correct atleast. Im sure on the password and username.

 

The server name i enter like this:

<clustername>.azurehdinsight.net

 

Does anyone know how I can get more information on why it fails?

4 REPLIES 4
Super User IV
Super User IV

Re: Problems with connecting against Azure Spark on HDInsight

My first guess would be authentication, how are you authenticating, OAuth?


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

Code84 Frequent Visitor
Frequent Visitor

Re: Problems with connecting against Azure Spark on HDInsight

Hello,

 

Thanks for taking some time and trying to help me.

I login with the regular username and password that is registered through Spark on Azure (the admin user I use to access anything with spark). 

 

It can be good to know have been following this guide: https://azure.microsoft.com/sv-se/documentation/articles/hdinsight-apache-spark-use-bi-tools/ and im stuck at Step4 in the title "Use Power BI to analyze data in the Hive table"

 

 

 

AustinT Frequent Visitor
Frequent Visitor

Re: Problems with connecting against Azure Spark on HDInsight

A year later and I'm running into this issue, too! There seems to be some nuance that I'm missing about connecting to the cluster - although our authentication is set up to be a basic username and password. And we have no ports blocked to the cluster. What a headache!

AustinT Frequent Visitor
Frequent Visitor

Re: Problems with connecting against Azure Spark on HDInsight

I'm embarassed to say the "Gateway" issue is caused by disabling the Thrift servers in our cluster. We did this because our primary use cases are PySpark in nature and therefore do not require Thrift services. Re-enabling the Thrift server facilitates connection of PBI to the Spark cluster.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors