Solved: PQ can't load all colums

Schwinn123 · ‎03-30-2020

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

v-easonf-msft · ‎03-30-2020

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.

View solution in original post

Greg_Deckler · ‎03-30-2020

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Schwinn123 · ‎03-30-2020

Hi

where is the column parameter？

v-easonf-msft · ‎03-30-2020

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.