Error connecting CSV file April Update

[SUTTY]

Hello all,

I've loaded up my Power BI file after the April Update, 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 containing these files. 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. I have tried clearing permissions but to no avail.

Anyone got any thoughts on a cause/resolution please?

Many Thanks!

[v-yingjl]

If you have used April 2022 version(2.104.702.0), you can try to disable 'Power BI Desktop infrastucture update' feature in options to check this issue again.

In addition, you can uninstall the current version of Power BI Desktop and try to test previous version of Power BI Desktop (March version or eariler) and disable this feature as well.

Best Regards,
Community Support Team _ Yingjie Li

[SUTTY]

@v-yingjl many thanks!

I am using the MS version of Power BI - may be an issue with that too then!

As such I cannot find the 'Power BI Desktop infrastucture update' selection, and I may just have to download the March desktop version.