topic Re: Not able to merge Databricks cluster delta tables(location Abfs) with PowerBi for analytics Purpose in Data Engineering

Not able to merge Databricks cluster delta tables(location Abfs) with PowerBi for analytics Purpose

Prashant777 — Fri, 28 Apr 2023 05:24:54 GMT

Hi everyone .. i have an issue while connecting azure Databricks cluster delta tables(location Abfs) with PowerBi for analytics Purpose. but after succesfully linking cluster using Server Hostname and HTTP Path with powerbi is showing an 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'

I also mounted databricks notebook with azure data lake gen2 using SAS keys .

Re: Not able to merge Databricks cluster delta tables(location Abfs) with PowerBi for analytics Purpose

-werners- — Fri, 28 Apr 2023 10:51:48 GMT

Did you use the partner connect?

Makes the connection pretty easy.

Re: Not able to merge Databricks cluster delta tables(location Abfs) with PowerBi for analytics Purpose

Prashant777 — Sat, 29 Apr 2023 19:27:43 GMT

thanks .will try