As described in the title. I need to build reports in Tableau with data from salesforce and Tableau doesn't support fields with Text Area (long). So the only solution is the convert those fields to text Area. I have checked that in the system, those fields actually contain data less than 4096 characters which can be fit into text area. But are there any pitfalls in doing this? what are the other considerations?
As mentioned by @cropredy textArea field only supports 255 characters. If any of the record data contains more than 255 characters there will be data loss for those fields. Please find the below article for considerations while changing the different datatypes.