Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
Solved

Hello! Help with error

Hello community! I thank you in advance for your recommendations and sincere support to solve the following error, when I have updated the Data table it tells me that there is a match error and to re...
  • Eli_r06's avatar
    Eli_r06
    3 years ago

    Hello! thanks for your answer, I found the error, it was that 124 files had #N/A and power bi doesn´t recognize it.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi Eli_r06 

 

Can you show a screenshot of the error? From the current screenshot, the "changed type" step seems work and there is no error displaying. When and where does the error appear? Did you do any operation before it appeared?

 

Best Regards,
Community Support Team _ Jing

  • Eli_r06's avatar
    Eli_r06
    New Member
    3 years ago

    Hello! thanks for your answer, I found the error, it was that 124 files had #N/A and power bi doesn´t recognize it.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    3 years ago

    I saw the text I placed [Message = "The type of the value does not match the type of the column.", Detail = v], fieldTypes{i}}), you can find the error in 124 rows with data #N/A because they were fields with formula that showed error, what I did was check the error in the formula, correct the values and when updating the power bi I no longer got an error.

    Thank you for your reply 🙂

    • v-jingzhang's avatar
      v-jingzhang
      Community Support
      3 years ago

      Hi Eli_r06 

       

      Glad you have solved it by yourself and share the error cause with the community! Thank you! 

       

      Best Regards,

      Jing