cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Amelia
Frequent Visitor

Daily email even if the dataset hasn't changed

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.

8 REPLIES 8
v-huizhn-msft
Microsoft
Microsoft

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
Advocate II
Advocate II

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 = DATEDIFFMAX( '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
Microsoft
Microsoft

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
Super User
Super User

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi @GilbertQ

 

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

 

Hi @Amelia

 

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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

 

thanks @GilbertQ

Hi @Amelia

 

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors