Error converting data type VARCHAR to BIGINT

I'm currently attempting to profile a deep and wide dataset using SQL Data Profiler; however we I choose the Numeric Profile Data Type Option the Profiling Process Fails. Providing me with an Error stating:

Error converting data type VARCHAR to BIGINT

Is there any way that I can work around this without changing the table I am wishing to profile?

Background

The data set being profiled is an MS SQL Server 2014 data set that has been loaded from SAS data set; and has not been assigned the most appropriate data types from SQL.

Parents
No Data
Reply Children
No Data