Power Automate Button, how to automate button click daily?

Hi alya1 ,

Thanks for reaching out to the Microsoft fabric community forum.

The Power Automate visual in Power BI is designed for manual triggering only; it cannot automatically “click” itself daily. To run this process automatically, you should create a scheduled flow in Power Automate that executes every day. The original button can remain in your report for optional manual execution.

Connecting a Scheduled Flow to Your Power BI Report, the Apply to each error occurs because the scheduled flow does not receive the button payload (Power BI values), which is why it evaluates as Null.

To resolve it, create a Scheduled Flow using Recurrence as the trigger and set it to run daily. And Fetch Table Data from Power BI Service and use “Run a query against a dataset” action (Power BI connector). Then select your workspace and dataset, and write a DAX query to retrieve rows where the due date equals 10 days ago: 

EVALUATE
FILTER(
    'YourTable',
    'YourTable'[DueDate] = TODAY() - 10
)

Now feed the query output to your Apply to each step instead of Power BI values. This ensures a valid array is passed, resolving the Null error. Keep your existing email actions inside the loop, mapping the required fields.

Also please note that Scheduled flows need to query the dataset directly and can't use button triggers. Manual and scheduled flows can operate at the same time without issues, but make sure the flow has the right permissions to access the dataset. With this setup, your flow will run automatically each day, and you’ll still have the option to trigger it manually if needed.

Also thank you Anonymous  for your helpful resposne.

Hope this helps. Please feel free to rech out for any further questions.

Thank you .