topic Re: Failing PowerBi connection with data Bricks via SQL warehouse in Administration & Architecture

Failing PowerBi connection with data Bricks via SQL warehouse

Charansai — Fri, 11 Jul 2025 19:24:09 GMT

I'm encountering an 'Invalid credentials' error (Session ID: 4601-b5a6-0daf792752a2, Region: us) when connecting Power BI to an Azure Databricks SQL Warehouse using an SPN. The SPN has CAN MANAGE access at SQL warehouse, admin rights at account and workspace levels, and schema privileges (USE CATALOG, USE SCHEMA, READ VOLUME, EXECUTE, SELECT). Credentials were verified as correct, but the issue persists. Could this be due to an expired SPN token or a regional authentication service issue? Any troubleshooting steps or configuration checks would be greatly appreciated!

Re: Failing PowerBi connection with data Bricks via SQL warehouse

Khaja_Zaffer — Fri, 11 Jul 2025 20:19:37 GMT

Hello Sai

good day.

I am checking this issue.

Re: Failing PowerBi connection with data Bricks via SQL warehouse

Khaja_Zaffer — Fri, 11 Jul 2025 20:25:11 GMT

Can you please confirm whether you checked SPN and it has validity?

Re: Failing PowerBi connection with data Bricks via SQL warehouse

Charansai — Fri, 11 Jul 2025 20:54:58 GMT

The SPN has properly setup and it has validity

Re: Failing PowerBi connection with data Bricks via SQL warehouse

Khaja_Zaffer — Fri, 11 Jul 2025 22:12:34 GMT

Hello Sai,

Can you try making a connection using PAT tokens? between I am create a repo to chekc the issue. PAT tokens are highly recommeneded and easiest way to use.

Re: Failing PowerBi connection with data Bricks via SQL warehouse

Khaja_Zaffer — Fri, 11 Jul 2025 22:17:22 GMT

Can you also cut a ticket with Azure? Because the Azure support engineer will have a better chance to look into the issue. cut a ticket with azure databricks the support engineer from MSFT will look into this else he will cut a collab with power bI team internally to check the issue. sometimes networking is also reposible, not sure what network setup you have.

Re: Failing PowerBi connection with data Bricks via SQL warehouse

Charansai — Fri, 11 Jul 2025 23:33:54 GMT

If you could explain me what kind of network issues we I can check from my end and have a word with you. This is the critical issue we are facing.

Re: Failing PowerBi connection with data Bricks via SQL warehouse

Khaja_Zaffer — Sat, 12 Jul 2025 08:03:34 GMT

Hello sai, sorry for the experience 😞

I usually available at desk during EMEA time zone. Apologies for the delay.

Can you please try this?

In "Advanced settings" of the data source within the gateway configuration and set the "Connection Encryption setting for this data source" setting to "Encrypted". By default, a checkbox was set that allowed the gateway to choose the connection encryption setting - this needed to be overridden.

Once the gateway setting was changed (and basic username/password credentials re-entered) It will able to successfully create/execute the dataflow query.