Forum Discussion
Power query using another workbook as source truncates text fields
Well, that's interesting.
I was going through, step by step, to see exactly where in the process the field was being truncated. I had inserted a filter step to find a particular task I could post, as an example. I don't think that I changed any of my original steps but, through this process -- it now looks like is no longer truncating that field.
Very weird.
This is a weekly process that I run. I'm going to see if it works again next week, and will update this post then, if that's okay.
I'm curious if the original file you were importing was actually exported from another system. I ran into the same issue. My solution was to open the data file and re-save it. Then the fields that were getting truncated to 255 characters imported fully.