Forum Discussion
PBI Dataflows failed connection to Azure Databricks using MS Data Gateway
Hi kkitsara ,
Thanks again for your patience and for providing more details! I’d be happy to clarify how to check if the On-Premises Data Gateway is set up to support OAuth authentication and what configurations might be needed.Not all data sources support OAuth passthrough when using the On-Premises Data Gateway.
Power BI Data Gateway – Supported Data SourcesIf OAuth authentication is not supported for Azure Databricks via the On-Premises Data Gateway, you may need to use Personal Access Token (PAT) or Service Principal authentication instead.
Since OAuth authentication requires Azure Active Directory (AAD) login, the On-Premises Data Gateway must be able to connect to Azure AD endpoints without network restrictions.
If your organization uses a proxy, make sure the gateway is configured to work with it:
How to Configure Proxy for On-Premises Data Gateway
If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
Hello Anonymous
Thanks again for your follow-up.
Points 1 and 2 are already checked.
Also our App registration used for OAuth integration is on the same account with PBI service.
Databricks is on AWS, but we are using Azure Databricks connector (as suggested on MSFT documentation)
Could you please clarify more about point 3?
Check the gateway is set up to support OAuth authentication. This might involve configuring the gateway to use the correct authentication method and ensuring it can communicate with Azure AD.
What kind of configuration is needed?
Regards,
Kostas
Hi kkitsara ,
Thanks again for your patience and for providing more details! I’d be happy to clarify how to check if the On-Premises Data Gateway is set up to support OAuth authentication and what configurations might be needed.
Not all data sources support OAuth passthrough when using the On-Premises Data Gateway.
Power BI Data Gateway – Supported Data Sources
If OAuth authentication is not supported for Azure Databricks via the On-Premises Data Gateway, you may need to use Personal Access Token (PAT) or Service Principal authentication instead.
Since OAuth authentication requires Azure Active Directory (AAD) login, the On-Premises Data Gateway must be able to connect to Azure AD endpoints without network restrictions.
If your organization uses a proxy, make sure the gateway is configured to work with it:
How to Configure Proxy for On-Premises Data Gateway
If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.