cancel
Showing results for 
Search instead for 
Did you mean: 
Administration & Architecture
Explore discussions on Databricks administration, deployment strategies, and architectural best practices. Connect with administrators and architects to optimize your Databricks environment for performance, scalability, and security.
cancel
Showing results for 
Search instead for 
Did you mean: 

Connect Community Edition to Power BI Desktop

OU_Professor
New Contributor II

I have submitted this question several times to Databricks over the past few weeks, and I have gotten no response at all, not even an acknowledgement that my request was received.

Please help.

How can I connect a certain dataset in Databricks Community Edition to Power BI desktop?  The documentation I’ve found is generic in the sense it only connects to random files in my opinion.  I want to connect to certain datasets in DB Community so that I can build visualizations in Power BI desktop. 

When I took the course as a student, we connected the DB Community edition to Power BI Desktop in a very straightforward way.  Then, we would simply take the JDBC/ODBC link, massage it a bit, and then simply paste it in the Power BI data connection screen.  For example, if this is the link on the Compute screen in DB Community edition:

jdbc:databricks://community.cloud.databricks.com:443/default;transportMode=http;ssl=1;httpPath=sql/p...

We would simply massage it a bit so that it would be whittled down to this string:

https://community.cloud.databricks.com:443/sql/protocolv1/o/7574958165221865/0817-135805-u7j57skj

We would then simply paste this link in the PBI Spark connection.

That connection would give me access to all of my tables, views, etc. from DB Community edition.

Today, I try using the same method I used when I took the class in the fall of 2021, but it does not work now.

I've also tried using the Azure Databricks connection in PBI, but it does not seem to work either.  I enter the Server Hostname and HTTP Path, log in to PBI, etc.  However, PBI connects to some random tables in Databricks.  How can I connect to a dataset I have in Databricks?

Thank you in advance.

1 REPLY 1

Knguyen
New Contributor II

Hi @Retired_mod,

It seams the Commnity Edition doesn't let us to generate the personal-access-token any more. Could you let us know some where we can get the token in the Comminity Edition?

Thanks.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group