Forum Discussion
Power Query not loading all columns
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.
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.
I should have realized there was already a join in the Navision table. So that is the error of my ways