Error Message: "Value Encoding failure - Data ID range is too large"

Question

Hello,&nbsp;&nbsp;There is a problem happening with my Power BI file. I cant update my data.&nbsp;The following message appears to me:"Value Encoding failure - Data ID range is too large"&nbsp;I don't know what to do, because untill last week it was everything ok with the file.&nbsp;Does anyone have a clue about what can be happening?&nbsp;Thanks!

v-diye-msft · Answer

Hi&nbsp;AugustoRadames&nbsp;
&nbsp;
It will appear if&nbsp;some values have an extensive character length. Please kindly check your data.
&nbsp;

augustoradames · Answer

Hi&nbsp;v-diye-msft&nbsp;,Thanks for your awnser.&nbsp;I'm trying to check my data, but untill now I can't find anything&nbsp;Do you have any tip about how can I check the character length in the Power Query?&nbsp;

v-diye-msft · Answer

Hi&nbsp;AugustoRadames&nbsp;
&nbsp;
You can use the&nbsp;Text.Length function:
https://docs.microsoft.com/en-us/powerquery-m/text-length&nbsp;
http://www.dagdoo.org/text-length-function-power-query/&nbsp;
&nbsp;
Here's related post could be your reference:
https://community.powerbi.com/t5/Desktop/Error-Message-Value-Encoding-Error-Data-ID-Range-is-too-Large/m-p/480158#M223479&nbsp;
&nbsp;
&nbsp;

Forum Discussion

Error Message: "Value Encoding failure - Data ID range is too large"

3 Replies

Related content

error message

Direct Lake optimized for large volumes of data - what does it mean "large"?

Snowflake connector: "We cannot convert the value null to type Text"

Propoperties Issue - "Value" instead of list of columns

subtotal not work in metrics (value has "if" statement)