Forum Discussion

jeaninnes's avatar
jeaninnes
Frequent Visitor
9 years ago
Solved

Auto Refresh date conversion issue - Dynamics 365 connectivity

Hi there,  I am really hoping that someone can help with this issue that we are having.  I really like the potential of Power BI - but this particular issue is making it unusable in our organisation...
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi jeaninnes

     

    What I can confirm from the Microsoft Power BI Team is that all the Power BI Servers Date/Time is stored as UTC.

     

    I am also based in Australia (Brisbane) which is GMT + 10 so what happens is that when you view your dates locally it will be based on GMT + 10.

    But when you upload it to the Power BI Service (Any data centre including Australia) the dates will be in UTC.

     

    So what I have done with my datasets is to offeset the Date/Time by 10 hours, so that when it uploads to the Power BI Service it takes this into account and displays correctly. Which in your example will make it show as 01 Oct.

     

    I would then create a new custom column in the Query Editor as follows below where the name of my existing column is called: SalesDateTime

    =[SalesDateTime] + #duration(0,10,0,0)

    That will then add 10 hours to your Date/Time.

jeaninnes's avatar
jeaninnes
Frequent Visitor
9 years ago

Thanks for the prompt reply.  From my research, I thought this was one of the workarounds available.  I haven't been able to get it to work so far (!).  I created a new column and added 10 hours to the date.  I've then based my charts on the adjusted date.  I'm still getting issues.

 

I'm going to start one of our reports from scratch, start with something really simple and try it again.

 

 

GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi jeaninnes

 

I think that would be the best way, something simple so that you can see if it is working as expected and then take it from there.