Data Model error

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.


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


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.

@Sergei Baklan 

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


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. 


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


Now refresh Error disappeared. Field Day 1 as well.