Forum Discussion
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.
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.
6 Replies
- lbendlinSuper User
Power Automate already has a built-in scheduler. No need for Power BI Service.
- marc_freiHelper 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
- lbendlinSuper 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