Forum Discussion

Geetha21's avatar
Geetha21
Frequent Visitor
1 year ago
Solved

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 tabl...
Need Help
  • BhavinVyas3003's avatar
    BhavinVyas3003
    1 year ago

    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.

  • v-menakakota's avatar
    v-menakakota
    1 year ago

    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's avatar
Geetha21
Frequent Visitor
1 year ago

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's avatar
v-menakakota
Community Support
1 year ago

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.