Forum Discussion

Pyb's avatar
Pyb
New Member
3 years ago
Solved

How to use Power Automate Desktop Flow op Power BI

I would like to trigger a Desktop flow with Power Automate, using the Power Automate visual in Power BI. But I only get the option to use Cloud flows. Is there an option to use desktop flows on PBI? ...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    Your only semi viable option for data write back at the moment is to use a PowerApp visual, a data source in direct query mode, and automatic page refresh.  That disqualifies any local data sources, and will require you to have PowerApp licenses for SQL server (for example).  

     

    Another hack is to use Sharepoint lists and powershell shenanigans to sync these with a SQL server table.   Makes the UX worse.

     

    If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Is that just for you or are you planning to roll this out to other users at some point?  Sounds like a solution looking for a problem?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

It is just for me. This construction is just a prototype, so problems with rolling out are not a concern.