Forum Discussion

mdc7's avatar
mdc7
New Member
2 years ago

Subscription email not sending after data refresh

Hi All,   I'm having an issue with email subscriptions for a Power BI report. I have a Power BI report that uses a DirectQuery connection to Azure Analysis Services and I set up an email subscripti...
Need Help
Jonvoge's avatar
Jonvoge
Most Valuable Professional
2 years ago

Hi mdc7

 

When you setup subscriptions in the service to run after data refresh, it is limited to being sent out once a day. How often is your refresh running?

 

As an alternative option, you may look into using Power Automate for your refreshing and scheduling: Refresh your Power BI dataset using Microsoft Flow | Microsoft Power BI Blog | Microsoft Power BI

 

You could create a flow to refresh your dataset on a custom schedule, and after a succesful refresh send an email that links to the report, or even exports the report to a file attachment.

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

  • mdc7's avatar
    mdc7
    New Member
    2 years ago

    Hi Jonvoge, thanks for your reply!

     

    The refresh runs once a day and I've tested the email subscription for a couple of days and I've never received any emails (checked the spam folder and added the Power BI email alias). However, I've tested the email notification on the report using Live Connection instead of the DirectQuery query mode and the subscription worked. We have to use the composite model for this report to leverage the field parameter function and would appreciate any suggestions on getting the email subscriptions worked for composite models.