Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Server Refresh Changing SharePoint Timestamp - Desktop Version Works Just Fine

I have a dashboard that I created with PowerBI Desktop, which I publish to workspace that many people in our organization have access to. The dashboard sources data from a SharePpoint List.   Where...
Need Help
  • GilbertQ's avatar
    GilbertQ
    4 years ago

    Hi Anonymous 


    The reason I think that this happens is that when it gets the ID Created date it gets it from the local time of the PC/Server that it is on

     

    When you are working on your PC it uses your local time. But when data is uploaded to the Power BI Service it is then on the Power BI Servers times which is UTC. 


    What would would need to do is to add 5 hours to the ID created time so when it is in the Power BI Service it will calculate the date correctly.

GilbertQ's avatar
GilbertQ
Super User
4 years ago

Hi Anonymous 


The reason I think that this happens is that when it gets the ID Created date it gets it from the local time of the PC/Server that it is on

 

When you are working on your PC it uses your local time. But when data is uploaded to the Power BI Service it is then on the Power BI Servers times which is UTC. 


What would would need to do is to add 5 hours to the ID created time so when it is in the Power BI Service it will calculate the date correctly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    GilbertQ 

     

    Ok! After some more investigation, I had to rollback some changes in Power Query that I had originally made trying to solve this. Once I did that I applied your suggestion everything worked!

     

    Thank you!

    • GilbertQ's avatar
      GilbertQ
      Super User
      4 years ago

      Hi Anonymous 

       

      That is awesome to hear thanks!