cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

Subscription sent at wrong time but timezone correct

I've got a scheduled refresh thats set to update data everynight at 10pm MST...but I got the reports sent to me a 6:00pm last night.

 

I have the scheduled refresh set at 10pm MST...so I'm not sure where else I can change this

 

Thanks!

5 REPLIES 5
Highlighted
Post Patron
Post Patron

Re: Subscription sent at wrong time but timezone correct

Email sent at proper time tonight only the date stamp in the email was still wrong time zone

 

It was sent at 10pm MST but detail in subscription shows...

 

The image above was generated at 4/30/2017 4:08:56 AM UTC

 

Is anyone else having this happen with their subscriptions?

Highlighted
Microsoft
Microsoft

Re: Subscription sent at wrong time but timezone correct

@unclejemima,

 

Currently, you will only get emails when the data changes when subscribe a report. So when setting schedule refresh for this report dataset, please select your local timezone, so that you data will refresh on proper time. And you can get the email on a proper time.

 

For the issue
The image above was generated at 4/30/2017 4:08:56 AM UTC
In Power BI services, your local will convert to UTC time. Currently, there is not such a option to change this time to your local time. You can add a local time to your report, please refer to the link below to see how to do it.
http://community.powerbi.com/t5/Service/changing-timezone-of-powerbi-service/td-p/153663

 

Regards,

Charlie Liao

Highlighted
Post Patron
Post Patron

Re: Subscription sent at wrong time but timezone correct

I get it but I don't.


When viewing reports in Power BI I'm using NOW() function.  This displays my local timezone (MST) in the desktop application.


When I'm in the Web Service it will display the timezones as UTC.

 

Thats fine, so I can create a new column in called NOW(-6) to get to MST, no?  But when I'm looking at the report in desktop I'll get the wrong time as I'll put -6 from the local...but in the online it will show correct.

 

So I have to do right for one, wrong for the other?

 

Let me know

Highlighted
Microsoft
Microsoft

Re: Subscription sent at wrong time but timezone correct

@unclejemima,

 

When viewing reports in Power BI I'm using NOW() function.  This displays my local timezone (MST) in the desktop application. When I'm in the Web Service it will display the timezones as UTC.

Currently, it's default behavior in current version of Power BI. So in your report, you'd better add two time, one is for local time, and another one is for UTC time.

 

Regards,

Charlie Liao

Highlighted
Post Patron
Post Patron

Re: Subscription sent at wrong time but timezone correct

Yes, but in the desktop version if I use NOW() it will display MST...then I rig a NOW+6 it will display UTC...then when I upload it the web version will show NOW() as UTC and the NOW+6 will show some other timezone what +12 from MST...

 

MST is -6 from UTC.

 

So.  I almost need 3 times on my report and depending on where it came from will still have one of them wrong.

 

I guess more importantly, what does the report running in Power BI online do with the other times?  Say I have a ODBC connection to a time field...will it change all those times as time +6 to get to UTC...so all the data is still relative.  Or will it increase the NOW time to UTC and leave the others local time zone?

 

Sorry just trying to figure out if this is just cosmetic or if it affects how the report displays if I have data with times in it.


Thanks!

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors