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

[Epsilon_Lin]

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!

[#2]

You may get more help in this forum https://techcommunity.microsoft.com/t5/microsoft-excel/ct-p/Excel_Cat

[#3]

@Tommykobberoe 

Hey Tommy,

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

Have a great day!

Best Regards,

Epsilon Lin