Oct 27 2021 12:43 PM
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.
Nov 03 2021 02:42 AM
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.
Nov 03 2021 03:18 AM
I should have realized there was already a join in the Navision table. So that is the error of my ways