data bricks error

[rudrap]

OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [HY000] [Microsoft][Hardy] (35) Error from server: error code: '0' Error message:Error getting columns:invalid configuration value detected for fs.azure.account.key

[v-chenwuz-msft]

Hi @rudrap ,

The problem comes from the data source.
Please check if the account you are using has permission to get the corresponding columns or if your credentials are configured correctly.

You can refer to this document to see if it helps you.

Azure Blob storage - Azure Databricks | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rudrap]

Tried to edit and clear permissons no use.

getting below error masgare and updated with the latest power bi version also,

DataSource.Error: ODBC: ERROR [HY000] [Microsoft][Hardy] (35) Error from server: error code: '0' error message: 'Error getting columns: Invalid configuration value detected for fs.azure.account.key'.
Details:
DataSourceKind=Databricks
DataSourcePath={"host":"adb-1110519374130402.2.azuredatabricks.net","httpPath":"sql\/protocolv1\/o\/1110519374130402\/0420-143300-duke854"}
OdbcErrors=[Table]