Forum Discussion
Is it possible to connect to Azure Databricks from a Data Flow within the PBI Reporting Service?
- 5 years ago
Found a workaround:
Use the 'Spark other' connector.
Set 'Server' as: https://SERVER_HOSTNAME:443/HTTP_PATH where SERVER_HOSTNAME and HTTP_PATH have been replaced appropriately.
Set 'Protocol' as: HTTP.
Set 'Username' as 'token'.
Set 'Password' as your token.
A guide to getting your server hostname and http path can be found here:
https://docs.databricks.com/integrations/bi/jdbc-odbc-bi.html
A guide to creating a token can be found here:
https://docs.databricks.com/dev-tools/api/latest/authentication.html
Found a workaround:
Use the 'Spark other' connector.
Set 'Server' as: https://SERVER_HOSTNAME:443/HTTP_PATH where SERVER_HOSTNAME and HTTP_PATH have been replaced appropriately.
Set 'Protocol' as: HTTP.
Set 'Username' as 'token'.
Set 'Password' as your token.
A guide to getting your server hostname and http path can be found here:
https://docs.databricks.com/integrations/bi/jdbc-odbc-bi.html
A guide to creating a token can be found here:
https://docs.databricks.com/dev-tools/api/latest/authentication.html