Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Import Dates from Excel - Seconds

Hi,

 

I've been importing dates with seconds from Excel, I need a process which doesn't have any manual fixes.

 

When I import date everything import fine, apart from the seconds. They are all defaulted to 00.

 

Does anyone have a solution to how the data is import in Power BI?

 

Thanks.

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I can't attach a screenshot.

     

    But the example is that

     

    23/12/2019 23:12:12 imports as 23/12/2019 23:12:00

     

    This happens for the whole file. However Power BI does know its a date and time stamp. 

    • v-piga-msft's avatar
      v-piga-msft
      Resident Rockstar
      7 years ago

      Hi Anonymous ,

      By my tests with the latest version of power bi desktop, I cannot reproduce your scenario.

      Please check if you have installed the latest version of power bi desktop(2.71.5523.941).

      In addtion, what data type of your date column in Excel file? Please set with Date type.

      If you still need help, please share a sample excel file which could reproduce your issue so that I could have a test on it.

      Best  Regards,

      Cherry

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

         

        Sorry about the wrong order of the screenshots I can't move them :(

         

        problem solved by manually formatting file in Excel

         

        Thank for picking this up Cherry v-piga-msft ,

         

        Below I've attached a screenshot of our data.

         

        Sample Data

        We're running

        Version: 2.70.5494.761 32-bit (June 2019)

         

        I've asked our IT to push out the the most recent one.

         

        By formatting column B, our problem is solved where the seconds are uploaded correctly (as seen in screenshot at top). However we do not wan't any manual process involved. Can this be solved in the Power BI end in the upload stage?

         

        Or could you suggest any other solutions?