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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
pkumarsharma
Regular Visitor

POWER BI Query Importing incorrect date

Hi All, My first post, so apologies if this has been already asked, but i could not find a solution to this.

 

In my sharepoint list the dates are correct 

pkumarsharma_0-1679546250603.png

 

but when imported they are imported to my power query they are a day behind with time attached to it.

pkumarsharma_1-1679546332239.png

I have seen post to manually add a column to reduce it by one day but I have many many tables and each has date column so its too much.

 

Why is it behaving in such way. 

Please advise.

1 REPLY 1
ppm1
Solution Sage
Solution Sage

It does that because your SharePoint dates are coming in as UTC. You can bring them in as datetimezone to start/confirm and then convert them in added steps from there.

 

Pat

Microsoft Employee

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

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

Top Solution Authors