Forum Discussion
Data Model error
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...
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.
SergeiBaklan you are the god? ❤️
Fixed my Problem!
Glad it helped, thank you for the feedback.