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

[Jkaelin]

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

[v-shex-msft]

Hi @Jkaelin,

How many characters 'data id range' column stored? How many columns? Can you please provide more detail informations?

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

[Jkaelin]

Hi @v-shex-msft,

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,

[v-shex-msft · Accepted solution]

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]

@v-shex-msft

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]

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]

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!