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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

date & time column has the data in the format xx:xx.x

while importing data from CSV , date & time  column has the data in the format xx:xx.x (e.g. 03:45.7).  However I import this into Excel, it will always import it as a time.

 

my steps action done with no success :

1. change  type to time/date - lead to error

2. detect data type - lead to error 

3. change CSV encoding type - not change get data from CSV in BIget data from CSV in BIGet Data from CSV in ExcelGet Data from CSV in Excel

Status: Needs Info
Comments
v-jiascu-msft
Employee

Hi @yairzafrany,

 

What's the format of these columns in the CSV? Can you share a sample please?

 

Best Regards,

Dale

Vicky_Song
Impactful Individual
Status changed to: Needs Info