Using Power automate to update databricks table from power bi dekstop

[Geetha21]

Hi team,

I am new user to power automate function.

I am interested to know based on the power bi visual selection, can I set up power autoamte to trigger a connection to existing databricks table and update the data of the table.

It would be helpful to know how to setup the connection from power bi to databricks using power automate. Is that possible?

Thanks in advance!!

[BhavinVyas3003 · Accepted solution]

Currently, Power BI visuals cannot automatically trigger Power Automate flows based on user selections. However, you can use the Power Automate visual in Power BI Service, which lets users manually trigger a flow after making a selection.

To update a Databricks table from Power Automate:

• Create a flow with an HTTP action that calls the Databricks REST API to run SQL commands or jobs updating your table.

• Pass the selected data from Power BI to the flow via the Power Automate visual inputs.

[Geetha21]

Hi @BhavinVyas3003, @burakkaragoz 

Thank you very much for providing me the information how I can proceed. Currently I dont have premium license to setup http (premium) action. I will try out to create a flow that calls Databricks REST API using HTTP action.

[v-menakakota · Accepted solution]

Hi @Geetha21 ,
Thanks for reaching out to the Microsoft fabric community forum.

Since the HTTP action in Power Automate requires a Premium license, and you're currently not using one, here is  another alternative approache:
You can create a desktop flow that runs a script (like Python or cURL) to call the Databricks REST API and update the table. This option is free and can be triggered manually from the Power Automate visual in Power BI Service.

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

Best Regards, 
Menaka.
Community Support Team

[Geetha21]

Hi @v-menakakota,

Thanks for the suggestion. It is really helpful how I can proceed further but I have 2 blockers now.

1. In the python script I dont want to pass the databricks token to connect to databricks REST API. Can you please help me with sample script how I can connect to databricks REST API without passing token?

2. From Power BI, which action should I use to call python script?

Thanks in advance!!

[v-menakakota]

Hi  @Geetha21   ,

We really appreciate your efforts and for letting us know the update on the issue.

Please continue using fabric community forum for your further assistance.

If you're looking to implement secure authentication (like avoiding hardcoded tokens or using service principals/OAuth for Databricks), it may be best to raise a support ticket with Microsoft Fabric.
Please refer below link on how to raise a contact support or support ticket. 
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Thank you,
Community Member.

[v-menakakota]

Hi @Geetha21 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster. 

Thank you. 

[v-menakakota]

Hi  @Geetha21 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily. 

 
Thank you. 

[v-menakakota]

Hi @Geetha21 

Thanks for reaching out to the Microsoft fabric community forum.

I would also take a moment to thank @BhavinVyas3003  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster. 

Thank you.

[v-menakakota]

Hi @Geetha21 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster. 

Thank you. 

[BhavinVyas3003 · Accepted solution]

Currently, Power BI visuals cannot automatically trigger Power Automate flows based on user selections. However, you can use the Power Automate visual in Power BI Service, which lets users manually trigger a flow after making a selection.

To update a Databricks table from Power Automate:

• Create a flow with an HTTP action that calls the Databricks REST API to run SQL commands or jobs updating your table.

• Pass the selected data from Power BI to the flow via the Power Automate visual inputs.

[burakkaragoz]

Hi @Geetha21 ,

You can use Power Automate to trigger actions from Power BI, but updating a Databricks table directly from Power BI Desktop via Power Automate is not natively supported out-of-the-box.

How you could approach this:

1. Power BI Button → Power Automate Flow:

   • In Power BI, you can add a Power Automate visual (button) to trigger a flow based on your selection.

2. Power Automate → Databricks:

   • Power Automate doesn’t have a built-in Databricks connector.
   • You can use an HTTP action in Power Automate to call a Databricks REST API, or use Azure Logic Apps for more advanced integration.
   • You need to prepare an API endpoint in Databricks (or via Azure Functions) that accepts data and performs the table update.

Summary of steps:

• Add Power Automate visual to your Power BI report.
• Design your flow to collect selection data and send it via HTTP action to Databricks (API or webhook needed).
• Handle the update logic on the Databricks/Azure side.

Important Note:
This flow is possible, but it requires some setup on the Databricks side to expose an API for updates. There’s no “one-click” integration.

Let me know if you need step-by-step details for a specific part of this process!
translation and formatting supported by AI