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 reaching out to the Microsoft Fabric Community Forum about the issue you are encountering.

Upon reviewing the provided information, below steps may assist you addressing the issue.

  • Ensure that the organizational account being used has the necessary permissions to access the data source.
  • Make sure that the MS Data Gateway is properly configured to handle OAuth authentication.
  • If OAuth login continues to fail, consider using PAT authentication as a temporary workaround while investigating the issue further.

Please refer the solved link for more understanding, this might help you.
Solved: PBI Gateway to Azure Databricks Connection Error: ... - Microsoft Fabric Community


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


kkitsara's avatar
kkitsara
Regular Visitor
1 year ago

Hi Anonymous 

 

Thanks for your reply.

Have some follow-up queries on your bullet points.

 

  • Which is the organizational account? Is it the Azure Subscription where the PBI service belongs to?
  • How can I ensure that the MS Data Gateway is configured to handle OAuth authentication? Do you have reference documentation for this? I struggle to find something relevant.

 

Thanks for assisting.

 

Regards,

Kostas