Forum Discussion

MikeCSmith's avatar
MikeCSmith
Frequent Visitor
8 years ago

Excel Date imported as null by Source/Navigation

I am importing an excel data extract created by JIRA that contains dates in columns 6 through 10.  In stead of bringing these in as data/time or even text it converts the data to null (blank in the s...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi MikeCSmith,

 

That's strange. You can upload your file to the cloud drive like OneDrive, GoogleDrive, then share the download link here. Please mask your private data first.

 

Best Regards,

Dale

  • MikeCSmith's avatar
    MikeCSmith
    Frequent Visitor
    8 years ago

    Our company policies will not let me post a file to the cloud outside of our firewall.  

     

    This is a pic of the relevant data in the query preview window as a result of "Get Data From Workbook."

     

     

     

    Here is a pic of the data I'm attempting to import.

     

     

    If I change the import file column format to 'General' then the data becomes a decimal date/time serial number and everything imports correctly.  But I want to avoid making the user modify anything in the extract data.