Importing date column while getting issue

[prinuce]

Hi Team, 

I m getting issue while importing data from sharepoint. issue is there is one Date column (ex- 10/08/2021) while importing in power bi it is showing 08/09/2021. Please help.

Data source:- 

Power BI

[mahoneypat]

Actually, you can add a custom column with this formula instead.

= Date.From(DateTimeZone.RemoveZone([DateTimeZoneColumn])

Or,  you can add a transform column step on that column and update the function part in the formula bar to this 

each Date.From(DateTimeZone.RemoveZone(_)

Pat

[mahoneypat]

That is likely due to SharePoint date columns being UTC format, and it is getting converted to your local timezone.  So that date is probably correct.  If you do want to make them match, you can just keep the date component from that column.  One way to do that is to first convert it to a text column, extract text before delimiter (use a space), and then convert it to a Date column.

Pat

[prinuce]

I tried but getting error
Expression.Error: We cannot convert the value "8/9/2021 6:30:00 PM" to type DateTimeZone.
Details:
Value=8/9/2021 6:30:00 PM
Type=[Type]

Please help!

[mahoneypat]

That value doesn't have the timezone component.  Has the type already been changed at this point?  Or is this the value from the source?  Without the timezone component, I wouldn't expect you to see that behavior (date doesn't match value in SP list).

Pat

[prinuce]

@mahoneypat

I am facing some issue its fixed in Power Bi query editor but once i published to power bi service again showing the previous date

[prinuce · Accepted solution]

Thank you @mahoneypat my issue has been, resolved! Thank you again