When you replace your data in the Analyst, your are able to chose the type of column. It is not possible with the Business Author.
When your column contains integer and text, the column becomes integer and you loose text data