Power Automate Button - auto trigger once a day

[Jano]

Hi there,

I have the requirement to send out a daily report as a csv attached to an email.

The csv data is comming from tables and measures in our central dataset.

I created a power automate button / flow within the powerbi service to send it out when the button is clicked - so far so good.

Now, I want to automatise the trigger to start every day at 6 am for example, not needing to click it.

In power automate, I can't see how I can schedule this flow, since the trigger is button click in PowerBI, which I guess then sends the data from PowerBI to PowerAutomate for further use.

I'd appreciate any guidance on how to solve this within PowerBI/PowerAutomate.

Best regards,

Jano

[chilianlin87]

I want to do the same. Did you find solution please?

[gujralh]

@Jano Have you received any solution yet to this request.

Please let me know if any solution you have found !

[v-yaningy-msft]

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

[Jano]

Hi @v-yaningy-msft 

from the documentation you linked I found this limitation:

"Create flows that you will use with the Power BI button trigger directly within the Power BI report. Do not go directly to Power Automate to create these flows as the trigger will not have access to the data fields necessary for creating the flow."

Seems like my request is not possible? Since it's the access to the data fields which gets lost when I change the trigger of the flow...

[Jano]

Hi @NandanHegde ,

the flow is dependent on the data received from PowerBI.
The steps are:

-> initalize a variable
-> append data to this variable (json from PowerBI table, published via app in the service)
-> build the csv
-> send the email with csv attached

As mentioned before, if I remove the powerbi trigger and add scheduling, the flow breaks because there is no data to build the csv with etc.

[Jano]

Hi @NandanHegde 

this doesnt seem to work.

If I switch the trigger to recurrence instead of powerbi button click, the flow fails:

"The execution of template action 'Auf_alle_anwenden' failed: the result of the evaluation of 'foreach' expression '@triggerBody()?['entity']?['Power BI values']' is of type 'Null'. The result must be a valid array."

I guess the data flow is triggered on powerbi, that's why it's not possible like this.

I cannot add the recurrence as an action below the powerbi button click trigger.

Any other idea how to solve this?

[NandanHegde]

Hey,

You can schedule a power automate to trigger daily once :

https://www.process.st/how-to/create-a-scheduled-flow-in-power-automate/

The button integration within PowerBI is another aspect but to schedule a power automtae, there is no dependency on powerbi. You can explicitly schedule it

[NandanHegde]

since based on the current implementation, the current manual trigger aspect, there are some additional steps at the beggining of the power automtae which can be deleted once it is scheduled.

Steps for email attachment : You can follow the below flow to make adjustments in your current flow

https://community.fabric.microsoft.com/t5/Service/Power-Automate-email-Report-as-pdf/m-p/3643567#M21...

and then set up the schedule as stated in #1