Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.