Forum Discussion

marc_frei's avatar
marc_frei
Helper I
4 years ago
Solved

PowerAutomate On Power BI button clicked (Automatic trigger)

Hi

 

I was wondering, is there a way to trigger automatically a Power Automate flow from Power BI Service?

 

I'm aware of the possibilty to export data via an R-Script in Power Query, but it would be drastically less time consuming (DAX Measures, Visual Filters, etc.) if there would be a way to trigger to Button e.g. once a day? 

 

Many thanks in advance.

6 Replies

  • Power Automate already has a built-in scheduler.  No need for Power BI Service.

    • marc_frei's avatar
      marc_frei
      Helper I

      thanks for your reply. I'm a aware of that run-scheduled-tasks.

      But I can't put this action before "On Power-BI button clicked", as this is a manual trigger.

       

      I'm thinking about building a Power Automate Desktop Flow which connect's to Power BI Service and Triggers the button

      • lbendlin's avatar
        lbendlin
        Super User

        No need to trigger the button. You can run DAX queries directly from Power Automate. We do that with a custom connector to the datasets/executequeries API call