Forum Discussion
Solved
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 r...
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.
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!
