Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
indhaa
New Member

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.

 

 

 

 

 

1 ACCEPTED SOLUTION
ChrisMendoza
Resident Rockstar
Resident Rockstar

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

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

image.png






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



View solution in original post

2 REPLIES 2
ChrisMendoza
Resident Rockstar
Resident Rockstar

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

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

image.png






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



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

image.png






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.