Forum Discussion
ferfer1900
Feb 22, 2022Copper Contributor
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 ...
TheChrisLewis
Apr 30, 2025Copper Contributor
Try Excel.Workbook(File.Contents("C:\MyExcelFile.xlsx"), [InferSheetDimensions = true])