Forum Discussion

subhendude's avatar
subhendude
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

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

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" whi...
Need Help
TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

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%20loaded%20your,characters)%20or%20536%2C870%2C912%20bytes%E2%80%9D.

 

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

 

All the best.

Theo 🙂