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 power bi desktop.

 

Any thoughts on what the below means?  I was importing several Excel files from a folder.  I'm thinking it could be a memory limit or data limit.  The underlying data seems fine.

Thank you,

Jaes

 

 

 

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

6 Replies

    • 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