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
MMC16
New Member

Date failure

Hi all, 

 

I have an unsual error which I am wracking my brain to try to fix, but cannot. 

As most spurious issues, I haven't made any changes and it just started happening randomly today. 

 

Data is storred in Sharepoint excel file in format as seen below. column B with dates in and is formatted as a date 

MMC16_0-1647263944237.png

 

When the connection to PBI is made, you can see the dates are not being pulled thorugh correctly. 

 

MMC16_1-1647264027630.png

 

Any ideas on solution or error fault? 

 

1 ACCEPTED SOLUTION
edhans
Super User
Super User

Convert to date using the Locale option.

edhans_1-1647267865557.png

 

Your formula would look like then when you press OK.

= Table.TransformColumnTypes(Source, {{"Date", type date}}, "en-BM")

Pick the correct locale for your data source, but Bermuda/English will work for dates in those formats.



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!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

1 REPLY 1
edhans
Super User
Super User

Convert to date using the Locale option.

edhans_1-1647267865557.png

 

Your formula would look like then when you press OK.

= Table.TransformColumnTypes(Source, {{"Date", type date}}, "en-BM")

Pick the correct locale for your data source, but Bermuda/English will work for dates in those formats.



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!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

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