Power query doesn't load all columns

%3CLINGO-SUB%20id%3D%22lingo-sub-3197991%22%20slang%3D%22fr-FR%22%3EPower%20query%20doesn't%20load%20all%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3197991%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20import%20a%20TCD%20from%20file%201%20to%20file%202%20using%20Power%20Qwery%20to%20automate%20it%20but%20when%20I%20laod%20the%20data%20the%20new%20table%20doesn't%20have%20all%20the%20colum%20from%20the%20first%20file.%20I%20don't%20understant%20what%20is%20the%20isue%20(I%20load%2010%2F20%20colum).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20your%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regard%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3197991%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3198126%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20query%20doesn't%20load%20all%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3198126%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1314392%22%20target%3D%22_blank%22%3E%40ferfer1900%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20highly%20probable%20the%20names%2Fnumber%20of%20columns%20is%20hard-coded%20in%20your%20query.%20For%20example%2C%20if%20you%20setup%20your%20query%20with%20a%20(source)%20table%20of%2010%20columns%20and%20the%20new%20(source)%20table%20consists%20or%2015%20columns%2C%20if%20your%20query%20doesn't%20dynamically%20manage%20the%20names%2Fnumber%20of%20columns%2C%20only%20the%201st%2010%20columns%20are%20taken%20into%20account%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20need%20more%20help%20with%20this%20please%20post%20the%20code%20of%20your%20query%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3198179%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20query%20doesn't%20load%20all%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3198179%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F75890%22%20target%3D%22_blank%22%3E%40L%20z.%3C%2FA%3E%26nbsp%3Bthanks%20to%20your%20concerne%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20have%20a%20true%20request%20because%20I%20use%20the%20excel%20process%20%22importation%20of%20data%20from%20excel%20files%22%20should%20be%20able%20to%20load%20all%20my%20TCD%20and%20like%20you%20can%20see%20it's%20load%20until%20september%20but%20my%20TCD%20finish%20in%20jully%2023.%20Not%20sure%20if%20it's%20more%20clear%20for%20your%20understanding.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ferfer1900_1-1645526634907.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F350299i7EEE70584C719FFE%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ferfer1900_1-1645526634907.png%22%20alt%3D%22ferfer1900_1-1645526634907.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EKind%20regard%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

I'm trying to import a TCD from file 1 to file 2 using Power Qwery to automate it but when I laod the data the new table doesn't have all the colum from the first file. I don't understant what is the isue (I load 10/20 colum).

 

Thanks in advance for your help

 

Kind regard

3 Replies

Hi @ferfer1900 

 

It's highly probable the names/number of columns is hard-coded in your query. For example, if you setup your query with a (source) table of 10 columns and the new (source) table consists or 15 columns, if your query doesn't dynamically manage the names/number of columns, only the 1st 10 columns are taken into account

 

If you need more help with this please post the code of your query 

@L z. thanks to your concerne 

 

I don't have a true request because I use the excel process "importation of data from excel files" should be able to load all my TCD and like you can see it's load until september but my TCD finish in jully 23. Not sure if it's more clear for your understanding.

ferfer1900_1-1645526634907.png

Kind regard

 

@ferfer1900 

 

I better see what you mean. Be aware that the Power Query Navigator (Navigateur for you) window only shows a preview of the sheet/table you select and that preview can be truncated for performances reason

 

So, what happens if you select "TCD Produit" in the Navigateur window and click on "Transformer les données" (at the bottom of the window), do you see all your columns in the Power Query Editor?