Missing most of the data in Excel import

[Elli]

I'm importing a local Excel file (.csv) to Power BI. It has 13 million rows but it's less than 1 GB. 

When I open the imported dataset, I only see the top left corner of the data (rows A1-A17).  I can't figure out how to see the complete dataset. It only recognizes one of the fields (A10).  I need it to find all of the field headers in A10-F10 so I can filter the results to see only what I need.

The ultimate goal is to filter my results down significantly, and then download the smaller dataset so I can actually open it in Excel.

Any help is greatly appreciated!  Thanks so much.

[v-yuezhe-msft]

Hi @Elli,

Please help to post a screenshot about your sceanrio. Besides, would you mind sharing me the Excel file/ I will test it in my Desktop. 

Thanks,
Lydia Zhang

[BhaveshPatel · Accepted solution]

When you go to the Edit Queries Mode, You can go to the Home Tab ans select choose columns to see alll the avaialble columns in your dataset. See the attached screenshots for more information.

Choose ColumnsSelect Load more.