Forum Discussion

Copper Contributor

Nov 18, 2020

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...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Nov 19, 2020

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.

Erin412
Copper Contributor
Nov 19, 2020
SergeiBaklan
How did you determine what columns needed renamed? How do I know what's incorrect vs. correct?
- SergeiBaklan
  Diamond Contributor
  Nov 20, 2020
  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.
  
  In Power Pivot let rename DAY to Day and keep Day 1 as it is
  
  Now refresh Error disappeared. Field Day 1 as well.
  - Robin1999
    Copper Contributor
    Mar 28, 2024
    SergeiBaklan you are the god? ❤️
    Fixed my Problem!