Views:

Applies to Product - Power Apps
 

What’s happening?
The customer is seeking a solution to connect and query the Azure Databricks Catalog table from a Power Apps canvas app.
 

Reason:
Currently, there is no Azure Databricks connector available in Power Platform, and the Azure Databricks API is not public.
 

Resolution:

  1. Build a Custom Connector to Azure Databricks.
  2. Use the On-premise Data Gateway to call the private API from the Custom Connector.
  3. Since the API Key option is not available with the on-premise data gateway, create a Policy to deliver the API Key in the Header:
  4. Enable the “on-premise data gateway” option.
  5. Select the Authentication type (for testing, "No authentication" can be selected).
  6. Create the Policy with the following details:
    • Name: Name of your policy
    • Template: Set HTTP header
    • Operations: Choose your ‘Actions’.
    • Header name: Authorization
    • Header value: Provide in the format {NAME} $API_KEY
    • Action if header exists: override
    • Run policy on: Request
  7. Test the setup to ensure it works as expected.