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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors