Text Field Truncation for Some Columns in Power Pivot for Excel RRS feed

  • Question

  • I am importing an Excel file (.xlsx) straight into Power Pivot for Excel.  The file is largely text.  Some columns are being cut off at 255 characters but other columns are being brought into Power Pivot with a seemingly unlimited number of characters.  I can't figure out any reason these columns should be treated differently.  Does anyone know what Power Pivot is doing here?
    Friday, May 17, 2019 7:36 PM