Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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...
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
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
Hi!! Yes, for sure, thanks 😉
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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.