Invalid characters error message wne loading csv or excel file

Oct 27, 2015 12:06AM

Summary

Can't load csv or excel file into BI data model

Hi,

When I try and load either csv file with comma separator or pipe or excel .xls file I get invalid character error message.

I am trying to create a BI Publisher v 11.1.1.7.27 data model using both excel and csv option.

I have tried loading 1 row with 2 columns

200134,3

where col1 is text and col 2 number, with no header row and still get message (see attached image)

Any ideas?

Thanks