Forum Discussion
Power query doesn't load all columns
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 ...
Lorenzo 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.
Kind regard
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?