Forum Discussion
Unable to create PowerBI - Azure Databricks connection with OAuth
Hi Matias1256 ,
Use PAT authentication it will be good for production applications. We have a 50k + users tenant I never seen anyone using Oauth authentication on service with databricks connections.
Thanks,
Sai Teja
Community SupportHi Matias1256 ,
Thank you for reaching out to Microsoft Fabric Community Forum.
can you try below debug steps to resolve your issue.
- Generate a Personal Access Token (PAT) from Databricks under User Settings > Access Tokens
- Copy and use the PAT as the Account key in the authentication section
- Ensure the Databricks user has permissions to access workspace, cluster, and SQL endpoints
- Verify the on-premises gateway is installed, configured, and online
- In your data source settings, set Authentication method to Key
- Check that the host URL in the data source path is correctly formatted: {"host": "adb-<workspace-id>.<region>.azuredatabricks.net"}
- Use tools like Postman to test the token with a REST API call to validate it
- If the connection test fails but you’re confident in the setup, enable Skip test connection
- Make sure the gateway machine has internet access to reach the Databricks workspace
- Consider testing with a personal gateway mode in Power BI Desktop
- Recreate the data source in the gateway if configuration seems stuck or corrupted
- If issues persist, gather error logs and contact Microsoft or Databricks support for deeper analysis
Regards,
Chaithanya.
Hi,
We can create the connection with PAT as said in the first post. The problem is that OAuth doesn't work.
- v-kathullac
Hi sergej_og ,
I suggest reaching out to Microsoft Support by raising a ticket. Microsoft will analyze backend logs and provide a resolution
Below is the link to create Microsoft support ticket:
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticketRegards,
Chaithanya.
sergej_ogSuper User
I don't get you.
I don't have any reason to raise a ticket to MS.
Just try to support Matias1256.
Regards- v-kathullac
Appologies sergej_og ,
instead of tagging the Matias1256 i tagged you sorry for that
Matias1256 can you raise a support ticket for this so that they can assit you in addressing the issue you are facing.
Regards,
Chaithanya.