Power Platform Community Forum Thread Details

Hi Team,

in power app using azure databricks connector to load data from databricks table to power app. using 16 tables, and to write / update using power automate flows.

for azure databricks connection using OAuth authentication.

its working good.

But when sharing the app to other users, while they are accessing the app, prompting to enter server hostname and http path, what i have given when adding azure connector.

is there any method to bypass this, i.e., no prompt for app shared users.

very thankful for your valid suggestion.

Categories:

Building Power Apps

Connector development

Hi @sridharbabuk,

Microsoft docs confirm this is expected behaviour: "This is not a shareable connection. If the Power App is shared with another user, another user will be prompted to create a new connection explicitly."

OAuth authentication with Azure Databricks uses the On-Behalf-Of model, meaning each user authenticates with their own Entra ID identity. So every shared user gets prompted to create their own connection including entering server hostname and HTTP path, because the connection is tied to their personal identity.

To avoid this prompt for shared users you have two options:
1. Switch to Service Principal authentication. Create an Entra ID Service Principal, grant it access to Databricks, and use it in the connector configuration.

This is the only way to get a shareable connection where users aren't prompted, because the app authenticates as the service principal rather than the individual user. In the connector, select the Service Principal authentication type instead of OAuth.

2. Move Databricks calls to Power Automate flows. Instead of connecting Power Apps directly to Databricks, use Power Automate flows (with a service principal connection) to read/write Databricks data, and call those flows from Power Apps.

Users never see the Databricks connection prompt since it's entirely in the flow.
Option 1 is cleaner for read operations. Option 2 is what you already have for writes, so extending that pattern to reads would eliminate the connection prompt entirely.

Ref: https://learn.microsoft.com/en-us/connectors/databricks/

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

💼 LinkedIn

▶️ YouTube