Forum Discussion
Refresh Time Incorrect
Hello,
In my .pbix file I have a refresh time stamp that works when I manually refresh the data.
I have published the report and set up a scheduled refresh for 8am, 9am, and so on. For some reason the scheduled refresh shows the wrong time in the time stamp by ~4 hours. I have checked the time zone and tried to look through other sources but can't find what might be causing this. Does anyone have any experience with this happening or have any suggestions?
I ran into this same issue, and what I believe to be causing this is that in PBI Desktop, the times are converted to your local time, but when published to the server they go to UTC. Therefore to solve for this, I convert my time column to my local timezone using the following DAX formula:
end_time_EST = [End Time] - TIME(5,0,0)This formula will subtract 5 hours from your date/time column. It will make your desktop file time look wrong, but when published to the server, it will be in the correct time. Now since you mentioned that your times are about 4 hours off, I would change that from a 5 to a 4 in the formula above.
2 Replies
I ran into this same issue, and what I believe to be causing this is that in PBI Desktop, the times are converted to your local time, but when published to the server they go to UTC. Therefore to solve for this, I convert my time column to my local timezone using the following DAX formula:
end_time_EST = [End Time] - TIME(5,0,0)This formula will subtract 5 hours from your date/time column. It will make your desktop file time look wrong, but when published to the server, it will be in the correct time. Now since you mentioned that your times are about 4 hours off, I would change that from a 5 to a 4 in the formula above.That worked perfectly. Thanks for your help!
