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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.