Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
Power Automate already has a built-in scheduler. No need for Power BI Service.
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
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
this sounds very interesting. Do you have a tutorial for this?
I guess the custom connector needs a premium licensing?
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.
premium required, but a reason to go for premium 🙂
thanks for your support!