Forum Discussion
Header character limit
Good Afternoon Community,
I have built a PowerBi report that shows answers to survey questions in a graphcal representation. It is very neat and works well, however, it seems my survey questions are too long because within the header when looking at the data, it cuts off the end of the text in the question.
Does anyone know a way around this, or why this is happening?
Best regards,
Jack
Hi Anonymous
Where do you store these questions? In column headers or in column cells? Based on my test, it seems the column header has a limit of 512 characters.
In column cells, Power BI supports up to 32766 characters of data in a column of TEXT Data Type (Reference link). So if the questions are longer than 512 characters, you can consider holding them in column cells rather than in headers.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
1 Reply
Hi Anonymous
Where do you store these questions? In column headers or in column cells? Based on my test, it seems the column header has a limit of 512 characters.
In column cells, Power BI supports up to 32766 characters of data in a column of TEXT Data Type (Reference link). So if the questions are longer than 512 characters, you can consider holding them in column cells rather than in headers.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.