Data Format Error Details: _______

Hi BeeTee ,
Thank you for reaching out to us!
It looks like Power Query might be misunderstanding some of the values in the column, trying to treat them as numbers even though it set the column to Text.Here are the steps which might help you:

• Click on the "Question" column and change its data type to Text again by going to the Transform tab and selecting Data Type > Text.

• Be aware that some values might have invisible characters, such as spaces or special symbols, which could be causing the conversion issue, use Power Query 'Clean' or 'Trim' function to preprocess the data if needed.

• Also, check in the Applied Steps pane on the right side, see if Power Query has added a "Changed Type" step automatically. If it has, you may delete this step and manually set the column type to Text instead.

Hope this helps,If so,consider accepting it as solution.