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: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

kh0050

Data Format issues

Submitted by on ‎01-08-2023 07:48 AM

Hi All, 

Happy new year, I am receiving a Data format error message (see screenshots below) which is a date format issue in a table when I load a table to Power BI. I tried changing the date format to date, date or time but no luck. Also, I have made regional changes in Power BI and locale changes but no results. I need help, please.

 

Screenshot 1

kh0050_0-1673192454879.png

 

Screenshot 2

kh0050_1-1673192730594.png

 

Many Thanks

Kabir 

Status: Investigating
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎01-09-2023 01:24 AM

Hi @kh0050 ,

 

Please make sure there is no extra space at the front of your date column. Can you please remove those extra characters if it hase.

 

For original post,you may refer 

Solved: DataFormat.Error: We couldn't parse the input prov... - Microsoft Power BI Community

 

Best regards.
Community Support Team_ Caitlyn

 

Idea Statuses