Data Model error

Question

I am getting the following error in Excel.

"We couldn't get data from the Data Model. Here's the error message we got:

An unexpected error occurred (file 'pcminorobjcoll.inl' , line 109, function 'PCMinorObjectCollection<class PCProperty, class NameHashSupport> :: SetNameAndUpdateCollection').

I have found various articles that have suggested going through and checking the source data headings. I did this and nothing seems to be out of the ordinary. https://contexturesblog.com/archives/2020/03/26/excel-pivot-table-refresh-error-with-data-model/

Is there anyone that can help me? The document is fairly large and used frequently by staff. I'd like to avoid recreating it, or tearing it apart. If possible.

sergeibaklan · Answer

TianlinZhu&nbsp;
On this forum are people who have no contacts with support team. Just users who have different experience and who is willing to share such experience. answers.microsoft.com forum is more oriented on support.
Another option for us is on ribbon Help-&gt;Feedback-Report a problem. Such feedbacks are monitored by Microsoft, but don't expect any answer or quick fix.
And of course, paid support is always an option. With it you definitely will be answered.
&nbsp;
Back to your issue. I have no 2016 to test, but I'd try to use explicit measures removing implicit ones. Other words, don't drag Final Rate 2 into the Values of PivotTable pane. Instead create in Power Pivot measure like
Final Rate 2, Total:=SUM( MyTable[Final Field 2] )
and use it in PivotTable. With renaming of the field on&nbsp;Final Rate2&nbsp;measure shall pickup such change and continue to work. Implicit measure in such case will disappear. In general it's a best practice to use explicit measures only and avoid implicit measures. Again, I didn't test this with 2016, jus played with renaming.
It could be another compatibility issues with old versions, some are widely known, some not.&nbsp;

tianlinzhu · Answer

Happy New Year! Thank you so much for all your help. God bless you!&nbsp;&nbsp;

robin1999 · Answer

SergeiBaklan&nbsp;you are the god? ❤️Fixed my Problem!

sergeibaklan · Answer

Erin412&nbsp;
For me renaming of columns in data model works, main issue here is to rename correctly proper columns.
If that's the same error reason.

erin412 · Answer

SergeiBaklan&nbsp;How did you determine what columns needed renamed? How do I know what's incorrect vs. correct?&nbsp;

Forum Discussion

Data Model error