Scheduled Refresh Errors

[Anonymous]

Hello- I've been running into an issue with the Scheduled Refresh. I have a line graph that shows hourly call volumes and it's depicted correctly in the app. When I have the Scheduled Refresh run, the times are all shifted 3 hours later. For example, 6:00AM data is now shown in the 9:00AM time slot.

Any help would be greatly appreciated!

AppScheduled Refresh

[GilbertQ · Accepted solution]

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:

Power BI – Did you know ALL Power BI Services Servers are in UTC? Now how to handle it for Dates & Times - Reporting/Analytics Made easy with FourMoo and Power BI

[GilbertQ · Accepted solution]

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:

Power BI – Did you know ALL Power BI Services Servers are in UTC? Now how to handle it for Dates & Times - Reporting/Analytics Made easy with FourMoo and Power BI

[Anonymous]

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?

[GilbertQ]

Thanks for letting us know.

[Anonymous · Accepted solution]

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