Forum Discussion

lawada's avatar
lawada
Icon for Helper III rankHelper III
5 years ago

send dashboard subscriptions with a quarterly frequency

hello, 

 

i have a quarterly analysis dashboard that needs to be sent to the management after each quarter. i know that the frequeny for the 

dashboards is restricted only to : hourly, daily,weekly,monthly or after data refresh. 

 

is there any possiblity that i create the email supbscriptions in a quarterly basis ?

 

thank you in advance.. 

Need Help

2 Replies

  • Geophffrey's avatar
    Geophffrey
    Regular Visitor
    3 years ago

    This is an old thread, but wanted to mention this in case someone else comes along with the same question.

     

    This is fairly easily accomplished through Power Automate using a daily recurrance trigger and a condition on this trigger of: @contains(createArray('0101','0401','0701','1001'), formatDateTime(utcNow(), 'MMdd')).  This will limit the trigger of the email to the first day after quarter-end.

     

    In the next step, using Export to File for Power BI will export the file.

     

    In the final step, Send an Email with the attachment.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    Use a manual process. Set yourself a reminder at the beginning of the quarter (or whenever) and then push the button.