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.

We loosely followed this article Using Power Automate to run DAX queries against your Power BI dataset (datalineo.com) Not sure about the licensing requirements. We are on Premium.

PowerAutomate On Power BI button clicked (Automatic trigger)

6 Replies

lbendlin
Super User
4 years ago
Power Automate already has a built-in scheduler. No need for Power BI Service.
- marc_frei
  Helper I
  4 years ago
  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
    Super User
    4 years ago
    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

Forum Discussion

PowerAutomate On Power BI button clicked (Automatic trigger)