Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

DanielElyRankin

Email Subscription Times incorrect

Submitted by on ‎11-22-2017 06:03 AM

In my workspace I had tested subscription emails.  

 

This is a hybrid setting between 'daily' email subscriptions and the data set refresh frequency. Though it asks for timezone, the scheduled cache refresh appears to ignore the TZ and emails based on UTC.  I receive emails intended for 6am EST at 1am EST (6am UTC).  I went a step further and left the TZ as EST and set the report to send out at 11am UTC and recieved the email at 6am EST as intended. I have had to set the dataset to refresh once per day at 11am UTC in order to get the above to email at 6am EST.   Otherwise, datasets that refresh in the morning (single updates per day) will only send out that night which is effectively now a full day behind.

 

My workaround may be complex, but I believe its both an issue if not understanding the Timezone on the settings for datasets page and a lack of robustness in the email subscription settings (ability to send a daily summary at a given time in a TZ).

 

Wed 11/22/2017 6:02 AM "You’re receiving this email because you subscribed to the ... The image above was generated at 11/22/2017 11:01:54 AM UTC."

 

Overall, PBI is a fantastic product, very exciting to see the progress being made.

Status: Needs Info
See more ideas labeled with:
3 Comments (3 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎11-22-2017 09:31 PM

Hi @DanielElyRankin,

 

Please check what's the region timezone set for the outlook email? Based on my test, in schedule refresh for dataset set timezone as UTC+8, dataset refresh starts from 11:30 AM and finished in 11:33 AM, and I also receive the subscribe at 11:33 AM due to the outlook timezone set as UTC +8 as well. 

 

q1.PNGq2.PNGq3.PNG

 

Best Regards,
Qiuyun Yu

Vicky_Song
Impactful Individual
Impactful Individual
‎11-22-2017 09:33 PM
Status changed to: Needs Info
 
Thejeswar
Resident Rockstar
Resident Rockstar
‎01-21-2018 09:16 PM

Hi Qiuyun Yu,

Even we are also facing the same issue in Power BI Subscriptions.

 

The Below is the Scenario.

I have set the Dataset to refresh at 6.00AM with Time Zone as (UTC+5.30). After this is set, for the immediate next day I receive the mail at 6.00 AM UTC+5.30. From the second day, the Subscription gets triggered at 11.30 AM UTC+5.30 which is 6.00 AM UTC

 

Looking at the mail body of the subscription mail, it can be seen that the Subscription is getting triggered at 6.00 AM UTC

 

"The image above was generated at 1/21/2018 6:02:24 AM UTC"

 

This happens for any dataset be it. Once we subscribe to it, only on the immediate next day, I get the mail at the set time of UTC+5.30 Time Zone. But from the second day, this happens at UTC Time Zone.

Idea Statuses