Data Model error

%3CLINGO-SUB%20id%3D%22lingo-sub-1900494%22%20slang%3D%22en-US%22%3EData%20Model%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1900494%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20getting%20the%20following%20error%20in%20Excel.%26nbsp%3B%3C%2FP%3E%3CP%3E%22We%20couldn't%20get%20data%20from%20the%20Data%20Model.%20Here's%20the%20error%20message%20we%20got%3A%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20unexpected%20error%20occurred%20(file%20'pcminorobjcoll.inl'%20%2C%20line%20109%2C%20function%20'PCMinorObjectCollection%3CCLASS%20pcproperty%3D%22%22%3E%20%3A%3A%20SetNameAndUpdateCollection').%3C%2FCLASS%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20found%20various%20articles%20that%20have%20suggested%20going%20through%20and%20checking%20the%20source%20data%20headings.%20I%20did%20this%20and%20nothing%20seems%20to%20be%20out%20of%20the%20ordinary.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcontexturesblog.com%2Farchives%2F2020%2F03%2F26%2Fexcel-pivot-table-refresh-error-with-data-model%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcontexturesblog.com%2Farchives%2F2020%2F03%2F26%2Fexcel-pivot-table-refresh-error-with-data-model%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anyone%20that%20can%20help%20me%3F%20The%20document%20is%20fairly%20large%20and%20used%20frequently%20by%20staff.%20I'd%20like%20to%20avoid%20recreating%20it%2C%20or%20tearing%20it%20apart.%20If%20possible.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1900494%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1906187%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Model%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1906187%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F399683%22%20target%3D%22_blank%22%3E%40Erin412%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20me%20renaming%20of%20columns%20in%20data%20model%20works%2C%20main%20issue%20here%20is%20to%20rename%20correctly%20proper%20columns.%3C%2FP%3E%0A%3CP%3EIf%20that's%20the%20same%20error%20reason.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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. 

3 Replies
Highlighted

@Erin412 

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.

Highlighted

@Sergei Baklan 

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

Highlighted

@Erin412 

You shall rename same field which you renamed in source table.

Let take your example. In source table we have column DAY and we added this field to PivotTable. More exactly data are added to data model.

 

In source table we rename DAY to Day and refresh data. In data model it will be added one more column Day 1 since data model is case insensitive. If you check PivotTable you see that it keeps connection to DAY, not Day 1. 

image.png

In Power Pivot let rename DAY to Day and keep Day 1 as it is

image.png

Now refresh Error disappeared. Field Day 1 as well.

image.png