Forum Discussion

9 Replies

  • krishnakanth240's avatar
    krishnakanth240
    Icon for Super User rankSuper User
    4 months ago

    Hi christeddy 

     

    You can find the error records from Power Query.

     

    Place the cursor in between Valid to Empty, it shows another display with 3 dots.

     

    • christeddy's avatar
      christeddy
      Regular Visitor
      4 months ago
      Load
       
      "Year 2009-2010
      Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataFormat.Error] We couldn't convert to Number.. '."

      Copied error.
      • collinq's avatar
        collinq
        Icon for Super User rankSuper User
        4 months ago

        Hey christeddy ,

        The "can't convert to Number" issue means that you have a column in a numeric data type but one of the fields is not actually a valid number.

         

        In Power Query find that column and find the errors and then fix them or the data tyhpe.

         

        WHile the error says that is numbers the name of the field indicates that it is a date field, is that right?  If it is a date field data type, then check for a bad or non-real date in that column.

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    4 months ago

    christeddy in this column (with the error), you are converting it to a number, whereas it clearly contains the text "A506401". Either fix the data at the source, or change the data type to text in the existing "change data type" step.

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support
    4 months ago

    Hi christeddy,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you parry2k, krishnakanth240 and collinq for the prompt response.

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa

    • v-achippa's avatar
      v-achippa
      Icon for Community Support rankCommunity Support
      4 months ago

      Hi @christeddy,

       

      We wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

       

      Thanks and regards,

      Anjan Kumar Chippa