cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
elliotdixon Member
Member

Timezone difference causing error - cant display NOW()

All going well till I have to give a presentation.  Cat Tongue

I live in New Zealand and discovered today that the PowerBI website seems to be running on GMT time.

Everything on PowerBI Desktop program is showing today as Friday (which it is where I am) but when uploaded online the PowerBI website still thinks its yesterday.

I created two measures to check.

NOW() and TODAY() and reuploaded the PBIX file - works fine on the desktop but online it shows an error
time now and today missing.jpg
Fix This - just removes the tile
See details gives the error
time now and today error message.jpg

 

is there any way I can change the timezone on the PowerBI site? Sure its somewhere I just need to change the setting.
Thanks

ED

11 REPLIES 11
Super User
Super User

Re: Timezone difference causing error - cant display NOW()

I'm not sure I follow this, it looks like from the error details that it has the right time and timezone, GMT+1300 (New Zealand Standard Time) and it shows Friday...


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

Proud to be a Datanaut!


elliotdixon Member
Member

Re: Timezone difference causing error - cant display NOW()

Hi @Greg_Deckler
It did indeed show my timezone in the error but the entire report still thought it was yesterday.
At 12pm my time (12am GMT) everything sorted it self out as our days match now.

Is there anywhere in PowerBI online you have to set your timezone?

Super User
Super User

Re: Timezone difference causing error - cant display NOW()

@elliotdixon, the only place that I know that you can set timezone is when you schedule your refresh.


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

Proud to be a Datanaut!


leonardmurphy Established Member
Established Member

Re: Timezone difference causing error - cant display NOW()

I was intrigued, so I did the same thing: created 2 measures (NOW and TODAY) and uploaded them to PowerBI.com.

 

I'm in US Central Time, so it's 9am right now. In Power BI Desktop, it shows as 9am. On the website, NOW() resolved to 3pm (which is GMT).

 

Being in central time, I doubt I'd get the error you're seeing (since I am never a day ahead of GMT).

 

But I would definitely send a frowny face if I were you.

 

I hope your presentation went well despite this!

---
In Wisconsin? Join the Microsoft BI Professionals - Wisconsin group.
elliotdixon Member
Member

Re: Timezone difference causing error - cant display NOW()

Cheers for the help everyone - I have lodged a frown with PowerBI. Hopefully this is something they can get on to quickly. Smiley Very Happy

beedeagle Frequent Visitor
Frequent Visitor

Re: Timezone difference causing error - cant display NOW()

hi team,

 

i have the same issue. the time display correctly, but it show the different time after i publish it on dashboard.

elliotdixon Member
Member

Re: Timezone difference causing error - cant display NOW()

 

Hmm - something seems to have happened with this.

I have noticed that there is a local times link within the Settings of the Dataset when I upload something now.

 

2016-05-18 08_25_01-Power BI.png

 

My measures are still incorrect but I wonder what this means.

 

Highlighted
AndrewDang Member
Member

Re: Timezone difference causing error - cant display NOW()

I have the same issue. 

 

@Greg_Deckler, would you please help us with this?

 

I have an issue with setting the right local time for our Power BI Service. I have the same measure to pull the current time. The Power BI desktop file pulls up 1/16/2017 4:36:02 PM which is the correct local time. However, the Power BI Service file pulls: 1/17/2017 12:36:02 AM, which is 8 hours ahead of the time. I am wondering where do I go about setting this local time on the Power BI Service side?

 

This issue results into not being able to pull up the overtime and data from yesterday starting from 4:00PM every day. It is pulling data for today (which is incomplete data)

 

Thanks

Andrew

JEROPS Frequent Visitor
Frequent Visitor

Re: Timezone difference causing error - cant display NOW()

Did this ever get resolved, as I have the same issue and haven't been able to 'google' a fix for this.