Forum Discussion

Jkaelin's avatar
Jkaelin
Resolver I
8 years ago
Solved

Error Message: Value Encoding Error - Data ID Range is too Large

Good afternoon,   *I searched for similiar posts but not much seems out there regarding this error, except that it could be something with underlying data.   *I run 8GB Ram, i7 processor, using p...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Jkaelin,

     

    I think this should related to query editor transform operations, have you enabled any advance transform operations in query editor?(combine, merge, append, refer other query, custom functions)
    BTW, I test to get data for excel table with hundreds of columns but can't reproduce your issue.

     

    Regards,

    Xiaoxin Sheng

Jkaelin's avatar
Jkaelin
Resolver I
8 years ago

Hi Anonymous,

 

I don't have a column labeled, "Data ID range".  I believe this is a microsoft error.  The table has 80 columns.  Sorry if I didn't initially provide enough information.  

 

I guess I'm asking if their is any source that explains errors so I know best where to troubleshoot?

 

Thank you,

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Jkaelin,

 

I think this should related to query editor transform operations, have you enabled any advance transform operations in query editor?(combine, merge, append, refer other query, custom functions)
BTW, I test to get data for excel table with hundreds of columns but can't reproduce your issue.

 

Regards,

Xiaoxin Sheng

  • Jkaelin's avatar
    Jkaelin
    Resolver I
    8 years ago

    Anonymous

     

    Thank you for your help.  After an extended period of testing, it appears some values have an extensive character length.  Although not resolved, I was able to pin-point the columns.  This thread helped me narrow down the troubleshooting.  Thank you.

    • AugustoRadames's avatar
      AugustoRadames
      Frequent Visitor
      6 years ago

      Hi Jkaelin ,

       

      I'm with the same problem as you were.

       

      Could you please tell me what did you do to find the value with an extensive character length?

       

      Thanks!

      • Jkaelin's avatar
        Jkaelin
        Resolver I
        6 years ago

        I had to count how many characters were in the some columns.  I used Power Query to trim the character lenght in some of the columns that had long names.  That may help!