Forum Discussion
Scheduled Refresh Errors
Hi Anonymous
This could be, because you are in a different timezone and in your dataset you are using TODAY() or NOW() which gets the datetime from the Power BI Servers which are set in UTC.
Please see my blog post below on how to solve this:Thanks! Though I didn't use this exact walkthrough, it helped for writing a formula that worked. I created a New Column in the Data window (not Query Editor) and used the following formula:
PBI Time Correction = 'TABLE'[Timeframe]-5/24
Hi Anonymous
This could be, because you are in a different timezone and in your dataset you are using TODAY() or NOW() which gets the datetime from the Power BI Servers which are set in UTC.
Please see my blog post below on how to solve this:
Hi Gilbert- Thanks again for the solution! One thing that recently crossed my mind, when using the formula "PBI Time = 'TABLE'[Timeframe]-5/24" is Daylight Savings. Would you know a way to have this formula correct for DST, so I wouldn't have to change this between 4 and 5 twice a year?
Thanks for letting us know.
Thanks! Though I didn't use this exact walkthrough, it helped for writing a formula that worked. I created a New Column in the Data window (not Query Editor) and used the following formula:
PBI Time Correction = 'TABLE'[Timeframe]-5/24