The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
There is a problem happening with my Power BI file. I cant update my data.
The following message appears to me:
"Value Encoding failure - Data ID range is too large"
I don't know what to do, because untill last week it was everything ok with the file.
Does anyone have a clue about what can be happening?
Thanks!
It will appear if some values have an extensive character length. Please kindly check your data.
Hi @v-diye-msft ,
Thanks for your awnser.
I'm trying to check my data, but untill now I can't find anything
Do you have any tip about how can I check the character length in the Power Query?
You can use the Text.Length function:
https://docs.microsoft.com/en-us/powerquery-m/text-length
http://www.dagdoo.org/text-length-function-power-query/
Here's related post could be your reference:
User | Count |
---|---|
77 | |
77 | |
36 | |
30 | |
28 |
User | Count |
---|---|
106 | |
96 | |
55 | |
49 | |
46 |