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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Date format error

Hi, 

 

Probably a stupid question but here it goes. 

 

From a SQL database I am trying to get some dates imported into Power BI Desktop, the date format is yyyymmdd, when I am trying to transform that into a recognized date format I get an error on all the dates. I am sure there is a simple solution for this but I am currently not able to find it. 

 

I cannot change the date format on the sql server.

 

Thanks in advance.

1 ACCEPTED SOLUTION
MarcelBeug
Community Champion
Community Champion

You cam convert to text first and to date next (in a separate step).

 

Example:

 

let
    Source = 20170312,
    #"Converted to Table" = #table(1, {{Source}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", type text}}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Changed Type",{{"Column1", type date}})
in
    #"Changed Type1"
Specializing in Power Query Formula Language (M)

View solution in original post

1 REPLY 1
MarcelBeug
Community Champion
Community Champion

You cam convert to text first and to date next (in a separate step).

 

Example:

 

let
    Source = 20170312,
    #"Converted to Table" = #table(1, {{Source}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", type text}}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Changed Type",{{"Column1", type date}})
in
    #"Changed Type1"
Specializing in Power Query Formula Language (M)

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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