Error connecting a file

[SUTTY]

Hello all,

I've loaded up my Power BI file after the weekend, and now cannot 'refresh' the data without a couple of errors occuring. After playing about with the model - the issue is caused by connecting a folder containing excel (CSV) files - and error codes also show when trying to connect a new folder. The folder connection worked fine prior to the april update, and the error codes are:

"object reference not set to an instance of an object"

"A Task's exception(s) were not observed either by Waiting on the Task or accessing its Exception property. As a result, the unobserved exception was rethrown by the finalizer thread"

EDIT: Found the excel file causing the issue, but no clue what the issue really means since it all worked fine previously? Is it a case of checking all the formats for each column? The only issue is the file has 1000+ columns🙃

Anyone got any thoughts on a cause/resolution please?

Many Thanks!

[v-stephen-msft · Accepted solution]

Hi @SUTTY ,

Check the solution provided by @PeterNL  in this post.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SUTTY]

Thanks @v-stephen-msft but as my file comes in a folder this solution hasn't worked for myself. 

It isn't on sharepoint, and replacing the path doesn't work.

Any other suggestions? I think I may just have to revert to the March Update to solve for the moment.

[Henry_EHC]

I am having the same issue. I suspect it's the data size...mine is 13052 Rows and 32 Columns large.