Estabilish connection with Databricks

[xersez23]

I need to estabilish a connection between Databricks platform and Power BI Desktop. The Spark connector requests the address of the Spark cluster server. The cluster I am running is created inside Databricks itself and I have no clue how to explicitly specify the server address.

Note that I am using Databricks Community Edition

[v-yuezhe-msft]

@xersez23,

Please contact databricks support about how  to determine the address of the spark cluster server, then use Spark connector in Power BI Desktop to connect to your data source.

And Power BI Desktop gives you an example.

http://example.com:10000/cliservice

Regards,
Lydia

[xersez23]

I need to import a csv from my databricks dbfs to Power BI Desktop. I am using the ODBC connector on Power BI and have done the Simba ODBC driver configurations on my desktop. The driver is unable to estabilish a connection and returns the following error:

[Simba][Hardy] (34) Error from server: Bad Status: HTTP/1.1 303 See Other.

All the driver configurations are correct according to the specifications given in the Databricks docs. I cant figure out what is the issue.

Alternatively, is there any other way to import data from Databricks dbfs to Power BI?

[gustavoleo]

The easyest way is using this driver (ODBC and 64-bits) go.helpbi.com/dbf