Power Query not loading all columns

%3CLINGO-SUB%20id%3D%22lingo-sub-2892380%22%20slang%3D%22en-US%22%3EPower%20Query%20not%20loading%20all%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2892380%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20pulling%20data%20from%20Navision%20SQL%20table%20and%20I%20only%20get%20145%20columns%20of%20the%20155%20columns%20not%20sure%20why%20the%20last%20columns%20will%20not%20load.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2892380%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2920214%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20not%20loading%20all%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2920214%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F359000%22%20target%3D%22_blank%22%3E%40Mainiac144%3C%2FA%3E%26nbsp%3B%2C%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20check%20your%20query%20step%20again%2C%20you%20might%20have%20step%20%22Removed%20Other%20Columns%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20Microsoft%26nbsp%3BMVP%2C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%20%26amp%3B%20like%20it%20to%20help%20the%20other%20members%20find%20it%20more.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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