cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

Subscription sent out daily, despite beeing set to weekly

Hello,

 

as the subject suggests, despite the weekly setting, all users in the subscription receive emails every day, hence I believe there is a bug. It results in users being spammed more often than necessary.

Also, with the weekly setting, how is it determined on which day of the week it's going to be sent out? I found 2 topics here, none of them has any satisfying answers or insight into the topic.

https://community.powerbi.com/t5/Service/Weekly-subscription-what-day-is-it-sent/td-p/163799

https://community.powerbi.com/t5/Service/Weekly-Subscription-when/m-p/474162#M49545

 

Mind you, I'm ok with not being able to set the day, but daily emails are a problem.

 

 

weekly.pngThanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate II
Advocate II

Hello there.

 

SQL Server data source, import mode.

 

Yes, I'm familiar with the article, specifically with this for Import "If the refresh schedule is daily, options are daily and weekly. If the refresh schedule is weekly, only option is weekly."

 

That said, the article doesn't state which day of the week would the weekly refresh work on, and how does changing the subscription affect that.

 

I think I now understand the behavior by observing it - any modification to subscriptions resets the day of the week to be a current day of modification.
An email will be sent on the first refresh after subscription was set-up, and then repeat itself weekly. However, now it appears that reason it was sent was that I've modified the subscription between days 1 and 2, hence it got sent again on day 2. Today (day 3), no subscription email.

 

You can mark it as "Delivered", Thanks.

 

 

View solution in original post

5 REPLIES 5
Highlighted
Community Support
Community Support

Hi @lehuok,

 

Which data source does the dataset get data from? Which connection mode do you use? 

 

Does the issue happen to this one specific report or other reports? 

 

In Power BI service, subscription emails are only sent when an underlying dataset is updated or refreshes depends on connection mode. You can refer to this article: https://docs.microsoft.com/en-us/power-bi/consumer/end-user-subscribe

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate II
Advocate II

Hello there.

 

SQL Server data source, import mode.

 

Yes, I'm familiar with the article, specifically with this for Import "If the refresh schedule is daily, options are daily and weekly. If the refresh schedule is weekly, only option is weekly."

 

That said, the article doesn't state which day of the week would the weekly refresh work on, and how does changing the subscription affect that.

 

I think I now understand the behavior by observing it - any modification to subscriptions resets the day of the week to be a current day of modification.
An email will be sent on the first refresh after subscription was set-up, and then repeat itself weekly. However, now it appears that reason it was sent was that I've modified the subscription between days 1 and 2, hence it got sent again on day 2. Today (day 3), no subscription email.

 

You can mark it as "Delivered", Thanks.

 

 

View solution in original post

Highlighted
Community Support
Community Support

Hi @lehuok,

 

It looks like you find the cause of the issue by yourself. 

Do you have any further question? If not, may I close this thread? 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate II
Advocate II

I would still suggest to have this behaviour documented better, as there is quite a few questions regarding this topic on the forum.

 

Yes, please close it, thanks.

 

 

Highlighted
Community Support
Community Support

Hi @lehuok,

 

You can share your feedback with author of the document

 

w3.PNG

 

Will close the thread as we discussed. Smiley Happy

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors