Power Automate Button - auto trigger once a day

Hi, Jano 

Based on your description, you want to transition from manually triggering the Power Automate flow using a button in Power BI to automatically running the trigger every day at 6am. You can try the following steps.

1. To modify a Power Automate flow, log in to Power Automate, navigate to My Flows and locate your existing flow.
Select your stream to edit.
2. Change Trigger, Remove the existing "Click Button in Power BI" trigger and add a "Repeat" trigger, which can be found under the "Built-in" tab when you search for new triggers. When you search for a new trigger, you can find it under the "Built-in" tab....
3. Configure the Repeat Trigger to run every day by setting the Interval to "1" and the Frequency to "Days". For the Start Time, specify the time you want the stream to start running, e.g. 6:00 AM.
4. Reconfigure the operations, if the flow uses data passed from Power BI button clicks, you may need to modify the operations to ensure that they are compatible with the new triggers (e.g., you may need to generate a CSV from the report using the Export File to Power BI Report operation).

Official document: Trigger a cloud flow from any Power BI report - Power Automate | Microsoft Learn

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum