While attempting to store a string, a string was found that was larger than the page size selected.

[subhendude]

I'm facing an issue while binding the datasouce with a table visual in Power BI. My datasource details are given below

It has around 17000 rows and 9 fields. There is a text field "errordetails" which contains characters ranging from 40 to 74000 in the different rows.

Binding the above datasource displayed the following error message

However if I remove the "errordetails" field from the table visual, it worked fine.

It looks like the issue might be because of large number of characters overflowing the memory page size. Do we know what is the limitation of number of characters that can be considered for a text field? Any other suggestion would also welcome.

Thanks

[subhendude]

Thanks Theo!

Though I tried to restrict the length 32766, still same issue persists

errorDetails = iff(strlen(errorDetails) > 32766, substring(errorDetails, 1, 32766), errorDetails)

[TheoC]

Hi @subhendude 

"In summary, then, there are two different practical limits on the maximum length of a text value in Power BI: the 32766 character limit on text being loaded into Power BI, and the 2.1 million character limit in DAX functions."- Chris Webb

https://blog.crossjoin.co.uk/2019/05/17/maximum-length-text-value-power-bi/#:~:text=Once%20you've%20....

Guessing that the 74000 characters is causing it given the maximum is 32766.

All the best.

Theo 

[TheoC]

Hi @subhendude 

"In summary, then, there are two different practical limits on the maximum length of a text value in Power BI: the 32766 character limit on text being loaded into Power BI, and the 2.1 million character limit in DAX functions."- Chris Webb

https://blog.crossjoin.co.uk/2019/05/17/maximum-length-text-value-power-bi/#:~:text=Once%20you've%20....

Guessing that the 74000 characters is causing it given the maximum is 32766.

All the best.

Theo 🙂