Excel Power Pivot - Cannot Refresh Data Model from its source data (Error Code 0x8007000E)

Good day,

I have some problems loading data properly in Power Pivot.

The data cannot be refresh or loaded properly. The same error always pops up, and I do not know what causes it? Anyone has an idea on this?

Actions Taken

(I removed the columns and cells with "Null" errors, but seemingly only simple tables can be loaded - 6 rows, whilst not so big tables - 500 rows cannot be loaded properly).

Equipment/Tools Detail

This version of Excel is 32 Bit running on 16GB Ram with auto update "disabled" by my company.

Thanks!