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:
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: