topic Re: Power BI with Databricks SQL Endpoint in Data Engineering

Power BI with Databricks SQL Endpoint

MariusC — Mon, 16 May 2022 12:37:00 GMT

Hello,

We are trying to load a Delta table from an Azure Data Lake Storage container into Power BI using the Databricks SQL Endpoint.

We configured the SQL Workspace data to have access to the ADLS Delta table and created a view; we are able to query the view from the Databricks SQL workspace.

We created a personal access token and downloaded the PBI file, but when we choose the Delta (or any other table from the metadata) in Power BI we have this error:

DataSource.Error: ODBC: ERROR [HY000] [Microsoft][Hardy] (35) Error from server: error code: '0' error message: 'org.apache.hive.service.cli.HiveSQLException: Error running query: Failure to initialize configurationInvalid configuration value detected for fs.azure.account.key

Also, on trying to connect to the "sample" tables in Databricks we have an error as well, just different:

Querying from Databricks Workspace works:

Does anyone have an idea how to proceed, please?

Thank you!

Re: Power BI with Databricks SQL Endpoint

-werners- — Tue, 17 May 2022 10:01:43 GMT

Not sure what is going wrong,

have you checked the docs?

Using Partner Connect

Without partner connect

Also do you have a PBI Gateway running?

Re: Power BI with Databricks SQL Endpoint

MariusC — Tue, 17 May 2022 10:13:00 GMT

I did follow the docs, Using Partner Connect.

Not sure if I need a PBI Gateway, as this is PowerBI Desktop, not the PowerBI service...

Re: Power BI with Databricks SQL Endpoint

-werners- — Tue, 17 May 2022 10:17:45 GMT

PowerBi is not my cup of tea so I can´t tell.

It could also be proxy settings/firewall etc.

Re: Power BI with Databricks SQL Endpoint

Atanu — Thu, 26 May 2022 09:34:02 GMT

@Marius Condescu Could you please include below spark config and try-

spark.hadoop.fs.azure.account.oauth.provider.type.ariaprime.dfs.core.windows.net org.apache.hadoop.fs.azurebfs.oauth2.ClientCredsTokenProvider

spark.hadoop.fs.azure.account.auth.type.ariaprime.dfs.core.windows.net OAuth

spark.hadoop.fs.azure.account.oauth2.client.id.ariaprime.dfs.core.windows.net {{secrets/<secrets>}}

spark.hadoop.fs.azure.account.oauth2.client.endpoint.ariaprime.dfs.core.windows.net https://login.microsoftonline.com/<token URL>

Re: Power BI with Databricks SQL Endpoint

MariusC — Fri, 27 May 2022 20:12:52 GMT

Hi @Atanu Sarkar Thank you for your answer, but the spark config cannot be applied to the SQL Endpoint, as far as I know - if it can, please let me know how.

We solved the issue by downloading the correct Power BI, we were using a different Power BI file than the one for SQL Endpoint.