I would like to run a Power Automate flow created with PowerBI on a schedule. Currently the flow is built into a PowerBI dashboard and the only option to run it is manually when: "On PowerBI button clicked". I need to run the flow daily and when I'm on vacation or OOO I won't be able to manually click the flow button. This will reduce the amount of manual clicks and we will have the opportunity to send the reports to our clients at any time on schedule.
If there is no current solution, please give a like to this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=c8349b43-e64a-ec11-a3ee-281878bd6ffd
did you ever solve this? I have a similar problem as my automation makes specific template files to upload in a different system.
I cant automate the export of a table to xlsx files so have to build my own automation to do this.
BUT I need it to happen every day.
At the moment I am going in a having to click on the button to start the automation.
You can create a new flow in Power Automate as a scheduled flow. So the trigger is no longer the button in Power BI but a fixed time/day. I actually think ther is a flow template for this.
Hi @jeroendekk, can you provide more details on how to do it? I'm not sure how to create the schedule if my datasource is PowerBI
What is the rest of your flow doing? You only show a screenshot of the trigger. You can create scheduled flows that interact with Power BI, but I think the trigger may limit which actions are available so it'll depend on what you're actually doing in the flow.
You can create new flows from make.powerautomate.com, one of the options is "scheduled cloud flow" and if you search the actions for "Power BI" you can see what's available.
yes it is the trigger which is the issue. Using the trigger
You can do a scheduled flow that has the action "query a Power BI dataset" as the first step. You give it a DAX query and it'll return whatever the result is to Power Automate. You would not use the "click a button" at all if you're going with scheduled. I did a video on the dataset query action here if that's useful: https://youtu.be/5-0KH0IiDjU?si=w1xlu1gVG7IxIFSO
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.