Time Zone Issue

[indhaa]

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.

[ChrisMendoza · Accepted solution]

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

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

[ChrisMendoza]

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