Forum Discussion

sieed's avatar
sieed
Helper II
9 years ago

Power BI.com manual refresh breaking visuals

I have create a calculated column which computes the "Minutes Since last refresh" and used a card to diaply this column.

 

Here's the calculate column formula: Num Mins Since last Refresh = datediff(Tablename(datetime), now(), minute). 

 

datetime is equal to  DateTimeZone.ToLocal(DateTime.AddZone(DateTime.LocalNow(),-5)). So it gives me central time. 

Now, when I do a "refresh now" in power bi web, the "Minutes Since Last Refresh" breaks and gives me the following error: 

Couldn't load the data for this visual
 
The query referenced calculated column 'TableName'[Num Mins Since Last Refresh] which does not hold any data because evaluation of one of the rows caused an error.
Please try again later or contact support. If you contact support, please provide these details.
 
I understand that power bi service uses some different time zone rather than the current local time. The questions is, what do I do to fix this? 
Need Help