Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Scheduled Refresh Errors

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

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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