I have a report which uses an excel file in sharepoint as its source. When I refresh the report in Power BI desktop, I get the error 'Object reference not set to an instance of an object'. This repor...
This error happened to me, it was a corrupted file. It seems to me that it's the same error as yours, due to this excerpt from the log: "Microsoft.Mashup.Evaluator.Interface.ErrorException: Specified value has invalid CRLF characters."
This procedure worked for me:
Expand the error details and if there is the message “Microsoft.Mashup.Evaluator.Interface.ErrorException: Specified value has invalid CRLF characters” it means that one of the files you are reading is corrupt. Try opening this file in the appropriate software, for example, if it is a spreadsheet, open it in Microsft Excel, and try to save it as a new file and replace the previous one.