Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Power automate connection - power BI

Hi All,
I have a power automate flow which I build inside the power BI, in order to trigger it I need to push the button.
 
How can I automate it that instead of clicking the button it will automatically run by dates that I will select? )for example, each 10th or 15th of the month)?
 
Thanks a head !
 
"Power Automate"
"Power BI"

3 Replies

  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    Icon for Super User rankSuper User
    1 year ago

    Anonymous Follow the below steps to trigger the flow on 10th or 15th of each month

    1. Delete your existing trigger (When a Power BI button is clicked)

    2. Search for a trigger named "Recurrence" and select it. 

    3. Now setup the frequency to day as below and click on three dots -> settings to configure the trigger condition.

    4. Copy paste the below code under your trigger condition and click Done. This will trigger your flow on 10th and 15th of each month.

    or(equals(dayOfMonth(utcNow()),10),equals(dayOfMonth(utcNow()),15))

    5. You can tweak the conditions if you want to set it for different days in the future.

     

    Thanks,

    Jai

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Ok But how will connect the recurrence to the BI?

      • Jai-Rathinavel's avatar
        Jai-Rathinavel
        Icon for Super User rankSuper User
        1 year ago

        Anonymous Are you trying to pass any data values through the Power Automate button in Power BI ?