We have a column titled "Unique_Identifier" that is typically 3 characters long and contains numbers and letters. The column is a TEXT column in order to accommodate the number/letter combinations. The problem we are facing is when we export "as a step in the project", the Excel file is having trouble with the values that contain the letter E (ex: '0E4'). It thinks that value is an exponential number. Further more, when uploading to Power BI, our example of '0E4' is shown as _x0030_E4. We get the odd formatting if we use the file directly from the SAS export, but the weird part is if we save the excel file, then upload to Power BI, '0E4' correctly shows as '0E4'. Any thoughts are appreciated. Thanks in advance!
... View more