Forum Discussion
Using Power automate to update databricks table from power bi dekstop
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!!
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.
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
10 Replies
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.
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.
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:
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.
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 AICurrently, 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.
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.
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 TeamHi @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.
