Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
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.
I am having the same issue. I suspect it's the data size...mine is 13052 Rows and 32 Columns large.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |