Forum Discussion

indhaa's avatar
indhaa
New Member
4 years ago
Solved

Time Zone Issue

Hi,

 

I'm new to Power BI. I'm trying to set a Power BI Tile on Power Apps.

So I created my data from SharePoint List and created the Report on Power BI desktop version. However after I created everything, I just noticed that my date field is one day behind then the date field on my SharePoint list. I did search on this community and I only saw that the desktop version is set to Local so I don't know why I'm having this issue.

 

Also since I'm new i'm having a hard time following some of the resolution provided in the old post. Hope I can correct the date field without impacting what I have done already.

 

 

 

 

 

  • indhaa - I am pretty certain SharePoint returns UTC time for Date columns. Try using something like:

    DateTimeZone.ToLocal(DateTimeZone.From([MonthStart]))

2 Replies

  • ChrisMendoza's avatar
    ChrisMendoza
    Resident Rockstar

    indhaa - I am pretty certain SharePoint returns UTC time for Date columns. Try using something like:

    DateTimeZone.ToLocal(DateTimeZone.From([MonthStart]))

    • ChrisMendoza's avatar
      ChrisMendoza
      Resident Rockstar

      indhaa -Your solution will depend on what you are getting too. 👀⤵