Applies to Product - Power Apps
What’s happening?
Customers are unable to create or alter relationships in a custom table due to exceeding the maximum allowable row size of 8060 bytes. This issue arises when the total size of the columns, including internal overhead, exceeds this limit.
What’s happening?
Customers are unable to create or alter relationships in a custom table due to exceeding the maximum allowable row size of 8060 bytes. This issue arises when the total size of the columns, including internal overhead, exceeds this limit.
Reason:
The error occurs because SQL Server has a hard limit of 8060 bytes per row. Each column consumes some of this space, and the size varies by data type. The presence of too many columns or large data types can lead to this error.
Resolution:
To resolve the issue, consider the following steps:
- Reduce Column Sizes: Check if any columns have larger sizes than necessary and reduce them.
- Use Sparse Columns: If many columns contain NULL values, consider using sparse columns to save space.
- Normalize the Table: Split the table into multiple related tables to reduce the row size.
- Remove Unused Columns: Identify and remove any columns that are not required.
- Check Existing Relationships: Review and remove any unnecessary relationships, as they add to the row size.
- Check for Hidden Columns: Ensure there are no hidden columns that may be contributing to the row size.
If the above steps do not resolve this, consider creating a new table with the required specifications, copying all the data over, and then dropping the old table.