Connection to Spark via PowerBI ERROR [HY000] [Microsoft][Hardy] (99)

[AfonsoQueiros13]

Hi guys, I have a HDFS Cluster running on 3 linux machines running Spark and I want to connect the Spark to Power BI on my windows computer in order to get clusters data. After configuring Hive Server and Spark ThriftServer, running on port 10001,  i get the following error:

The error appears to tell that it is impossible to connect via Hive  Power BI, but I tried to research another way to do it, but i can´t figure other options instead via Hive Server. Any idea of how can i resolve this?
Thanks in advance.

[AfonsoQueiros13]

Finally i resolved my problem. The solution in my case is to change database, from derby to mysql
1) Create MYSQL schema
2) create mysql metastore database and grant permissions to the user
3) connect spark thrift server to mysql database

[v-yiruan-msft]

Hi @AfonsoQueiros13 ,

It's glad to hear that your problem has been resolved. And thanks for sharing your solution here. Could you please mark your post as Answered? It will help others in the community find the solution easily when they face the similar problem with you. Thank you.

Best Regards

[AfonsoQueiros13]

Hi!! Yes, for sure, thanks 😉

[AfonsoQueiros13 · Accepted solution]

i used his tutorial to connect my spark to power bi, simply use instead tableau , power bi with spark connector:
https://community.tableau.com/s/news/a0A4T000002O4RxUAK/a-guide-to-setting-up-tableau-with-apache-sp...