PQ can't load all colums

[Schwinn123]

I have a data source which from an excel file has 50 colums data.  But after load this file to query editor in power BI.  It only shows me 49 colums data.  How can I adjust the data field or is there any other ways to solve this problem?

@v-lid-msft 

[Greg_Deckler]

Check the source line and see if it has a "Columns" parameter. This is quite common with CSV files.

[Schwinn123]

Hi 

where is the column parameter？

[v-easonf-msft · Accepted solution]

Hi , @Schwinn123 

If you lose data during the import of excel data to powerbi，please try steps as below before your load your data .

1. Normalize the data in the sheet in your excel into a table and save it

2.Choose Standardized form instead of Sheet1 when you load your data

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.