unable to pull csv data in powerpivot from csv or xls

Hi yesterday i was trying to pull data from a csv file,tried direct import from file and through folder but i was getting only one coumn of date when the query was imported,rest other colmns were igno...