Forum Discussion
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
- ChrisMendozaResident Rockstar
indhaa - I am pretty certain SharePoint returns UTC time for Date columns. Try using something like:
DateTimeZone.ToLocal(DateTimeZone.From([MonthStart]))- ChrisMendozaResident Rockstar
indhaa -Your solution will depend on what you are getting too. 👀⤵