PowerAutomate On Power BI button clicked (Automatic trigger)

[marc_frei]

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.

[lbendlin]

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

[marc_frei]

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]

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

[marc_frei]

this sounds very interesting. Do you have a tutorial for this?

I guess the custom connector needs a premium licensing?

[lbendlin · Accepted solution]

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.

[marc_frei]

premium required, but a reason to go for premium 🙂

thanks for your support!