Unable to connect to azure databricks from dataflow or datamart

[Samuel43]

Backgorund

I could connect azure databricks from powerBI desktop using "Server hostname" + "HTTP path" provided in SQL warehouse-Starter Point of azure databricks.

Problem

I cannot connect azure databricks from dataflow using the same setting (Server hostname + HTTP path) used in powerBI.

It will return error: Invalid credentials. (Session ID: bbaa7556-8d73-4487-99c7-beeb648f37c1, Region: us).

Despite I signed in using azure active directory

Also I tried using blank query in dataflow in which I copied code from advanced editor which has successfully connected to azure databricks already.

Invalid Credentials trying to connect to Snowflake in Dataflow only 

And another error returns: [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: Unauthorized/Forbidden error response returned, but no token expired message received.

What is the problem and please tell how to fix this problem in dataflow.

[Anonymous]

Hi @Samuel43 ,

1.Try changing the PAT for authentication.

2.Double-check the connection syntax used in the blank query within the dataflow. Ensure that it's correctly formatted and includes all necessary parameters for authentication. The error message you're seeing related to an "Unauthorized/Forbidden error response" suggests there might be an issue with how the connection is being established or with the credentials themselves. Recheck your token and permissions.

3.Check if there are any firewall rules or network restrictions that might be blocking the connection.

If none of these steps help, you can try manually connecting Power BI Desktop to Azure Databricks using a custom SQL query. You can find detailed instructions on how to do this in the Connect Power BI to Azure Databricks - Azure Databricks | Microsoft Learn

Best Regards,

Neeko Tang

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

[Samuel43]

Hi Neeko

Thanks for your suggestion.

1. May I know what is PAT and how to change it. I could only find password, personal token, azure active directory 3 ways to sign in.

2. Syntax should be no problem and I verified it with connected with azure databricks from powerBI but just couldn't work if I paste the same code to blank query.

3. I am checking if it's simply blocked by rules inside of company.

Kind regards,

Samuel

[Anonymous]

Hi @Samuel43 ,

I'm sorry I didn't explain myself better. PAT means Personal Access Token.

Best Regards,

Neeko Tang

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

[Samuel43]

Hi Neeko I tried personal token as well, unfortunately, it returned the same error...

[Anonymous]

Hi @Samuel43 ,

 If you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

Best Regards,

Neeko Tang

[Samuel43]

Hi Neeko

Thanks for your support all the way.

I have created a ticket in the way you provided and will update resolution once this problem is solved.

Kind regards,

Samuel

[Samuel43]

Hi Neeko

This problem has been fixed after our internal team provided me gateway.

Thanks