Forum Discussion

Schwinn123's avatar
Schwinn123
Icon for Helper I rankHelper I
6 years ago
Solved

PQ can't load all colums

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...
Need Help
Show and Tell
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    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.

     

Schwinn123's avatar
Schwinn123
Icon for Helper I rankHelper I
6 years ago

Hi 

where is the column parameter？

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
6 years ago

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.