Forum Discussion
Text cut off in Power Query Editor when imported from Excel
I was able to troubleshoot some more and found that the data source was saved as an Excel workbook using the version from 1990-2003. When saved as the modern version of Excel, this resolved the issue.
Hi VahidDM
Thank you for your prompt reply!
I tried using both the TRIM and CLEAN formulas in Excel before importing the data into the Power Query editor, but I still received the same error. Additionally, I used the LEN formula to count the number of characters and it appears there are about 750 characters in the cell.
In the Power Query editor, I counted the number of characters in each "Comments" column and it appears that only 225 characters are being imported. Do you know why this would be?
I was able to troubleshoot some more and found that the data source was saved as an Excel workbook using the version from 1990-2003. When saved as the modern version of Excel, this resolved the issue.