Forum Discussion

kkitsara's avatar
kkitsara
Regular Visitor
1 year ago
Solved

PBI Dataflows failed connection to Azure Databricks using MS Data Gateway

Hello,   We are trying to create a dataflow using Azure Databricks connector with OAuth login (AAD) and MS on-premise Data Gateway. The steps we follow: 1. Create a dataflow 2. Select Azure Data...
Dataflow
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi kkitsara ,

Thank you for your follow-up questions. I'm happy to provide more details to help you resolve the issue.

 

  • The organizational account refers to the Azure Active Directory (AAD) account used to authenticate and access resources within your organization. This is typically the account you use to log in to Azure services and Power BI. It is associated with your AAD tenant rather than a specific Azure Subscription.
  • Configuring MS Data Gateway for OAuth Authentication:
    • To ensure that the MS Data Gateway is configured to handle OAuth authentication, please follow these steps:
      1. Ensure your on-premises data gateway is up-to-date. You can download the latest version from the Microsoft Download Center.
      2. In the Power BI service, go to Settings > Manage Gateways. Select your gateway and verify that it is configured correctly.
      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.


Hope this helps, if so,please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

kkitsara's avatar
kkitsara
Regular Visitor
1 year ago

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