I am using multiple Excel and CSV files as data sources, and when I try to refresh my report, I get the following error message which doesn't specify which file it refers to:
Data source error: DataFormat.Error: We were unable to load this Excel file because we couldn't understand its format. File contains corrupted data.. Microsoft.Data.Mashup.ErrorCode = 10942. ;We were unable to load this Excel file because we couldn't understand its format. File contains corrupted data.. The exception was raised by the IDbCommand interface.
After checking all files, I found that they all have regular extensions (.csv or .xlsx), which doesn't match the error description. It would be helpful if the error message could specify which file is causing the problem.
