Forum Discussion
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...
Try this out:
1. Open a new blank workbook
2. Click on Get Data dropdown in Data tab
3. Select Blank query
4. In the Power Query editor, click on New Source
5. Select the CSV files folder path
6. Click OK to import to Power Query.
However, you just ensure that all the CSV files in the same folder has exact headings.
For example: If you have Name as heading for CSV file A. You must have Name as heading for CSV file A
1. Open a new blank workbook
2. Click on Get Data dropdown in Data tab
3. Select Blank query
4. In the Power Query editor, click on New Source
5. Select the CSV files folder path
6. Click OK to import to Power Query.
However, you just ensure that all the CSV files in the same folder has exact headings.
For example: If you have Name as heading for CSV file A. You must have Name as heading for CSV file A