Power Query not loading all columns

Copper Contributor

I am pulling data from Navision SQL table and I only get 145 columns of the 155 columns not sure why the last columns will not load.

2 Replies

Hi @Mainiac144 ,

 

Please check your query step again, you might have step "Removed Other Columns".

 

Regards, Faraz Shaikh | Microsoft MVP, MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

@Faraz Shaikh 

I should have realized there was already a join in the Navision table.  So that is the error of my ways