Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more

Reply
Ankit0111
New Member

undefined

‎04-19-2024 01:54 AM

Hi all, I am trying to load the data from a CSV file format. Issue is that date is in text format mm/dd/yyyy and when changing or transforming the data type to date in power query it is not recognising and showing error.

Labels:
Message 1 of 3
548 Views
0
1 ACCEPTED SOLUTION
dufoq3
Community Champion
Community Champion

‎04-19-2024 04:12 AM

Hi @Ankit0111, I guess this error comes from Changed Type step. Try to edit that step by adding this:

 

dufoq3_0-1713525126267.png

 


Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

View solution in original post

Message 3 of 3
520 Views
0
2 REPLIES 2
dufoq3
Community Champion
Community Champion

‎04-19-2024 04:12 AM

Hi @Ankit0111, I guess this error comes from Changed Type step. Try to edit that step by adding this:

 

dufoq3_0-1713525126267.png

 


Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

Message 3 of 3
521 Views
0
mahenkj2
Solution Sage
Solution Sage

‎04-19-2024 03:53 AM

Hi @Ankit0111 

 

you may try Date.FromText function in Power query. If it does not please share sample data and error content.

 

Hope it helps.

Message 2 of 3
525 Views
0

Helpful resources

Announcements
Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

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

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All