Forum Discussion
bdd9
3 years agoFrequent Visitor
Loading data from folder not loading all columns
Loading data from folder not loading all columns, I am not getting all 49 columns from my .xlsx files. I am only getting the 1st 39 columns. I believe it has something to do with the just gettin...
nickvanmaele
3 years agoAdvocate II
Update: I have tested by creating a completely new Power BI model.
I then created a custom function to process the files but the error remained when using the first file as the sample file. Starting over and taking each file in turn as the sample file, the error eventually disappeared when using the third file in the folder. Why this is so, is still an enigma to me, since all first three files in that folder have identical layouts, column titles, and data formats in each column.