Daily email even if the dataset hasn't changed

[Amelia]

Hi Guys

Can you set up the subscri[ptions to send out emals everyday even if there is no change in the data after a refresh. Our company would like daily emails to be sent out either way.

[v-huizhn-msft]

Hi @Amelia,

Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.

Thanks,
Angelia

[sumit4732]

Hi @Amelia,

There is a work around to it.

Please refer to the below steps for that:

1. Create a measure for CurrentDate in your PowerBI report using function Today().

        CurrentDate = Today()

2. Create another function to calculate the data available through, you can use data available from your source or use MAX() for the date/month column you have.

3. Now Create a measure which returns difference between the two dates.

       dataLag = DATEDIFF( MAX( 'Scale data'[Fiscal Month] ) , [CurrentDate] , SECOND)

Now you pin this dataLag to your dashboard and set Alert for value above zero. 
This will trigger the email notification every time your refresh the report, given you have at least one-second difference between last data refresh of the source and refreshing the report.

Hope this helps. 🙂 

-Sumit 

[v-huizhn-msft]

Hi @Amelia,

As the @GilbertQ said, the email subscriptions only work after the data has been changed. There is feature request here, you can vote it. If more people need it, it will be considered in the future.

Best Regards,
Angelia

[GilbertQ]

Hi @Amelia

Currently the way the email subscriptions work, is only after the data has been changed.

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-subscribe-to-report/

What you could possibly do, is to have the dashboard being refreshed and have say the Last Refreshed Date in your report, but it is in an area, and the text colour is set to white, so it is not visible, but that should then change on the data refresh via the On-Premise or Personal Gateway, which in turn will then send out the email?

[Amelia]

Hi @GilbertQ

im confused how would havig a last refreshed dat in the report help? 

[GilbertQ]

Hi @Amelia

By having something change within your dataset, it will then enable the Daily Email to be actioned and emailed.

[Amelia]

Ah ok, so dose it have to be somthing thats on the report? or just in the dataset?

thanks @GilbertQ

[GilbertQ]

Hi @Amelia

I think that just having it in the dataset should do the job.