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

New Contributor

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.





2 Replies

@Tommy Kobberoe 

Hey Tommy,

Thanks. Just realized that I have posted in a different forum.


Have a great day!

Best Regards,

Epsilon Lin