Smartsheet PowerBI data

Hello,

I am exporting a Smartsheet report data and importing to a PowerBI dashboard as the input data. One of the columns is a Contact column. When the data is directly imported into the dashboard some of the values are emails whereas some are names. All the values in the report are consistent and same and I also confirmed by exporting it to an excel. Any ideas on why Powerbi might be reading the data differently?

Thanks!

Answers