Add columns into source but will not come through into Power Pivot

nvcc_ite140galindo

New member
Joined
Jul 7, 2016
Messages
1
Reaction score
0
Points
0
I keep adding new columns of data in my source external table, but it will not translate over to PowerPivot when I refresh. Are there any potential reasons the information might not be picking up.
 

SteelReyn

New member
Joined
Mar 1, 2016
Messages
32
Reaction score
0
Points
0
PowerPivot seems to store a cache of what columns are in the database from my experience. Whenever I added new columns (e.g., to a stored procedure or table) I had to go the the Design tab and click Table Properties. That will bring up how you pull the table. Just click OK or Save (whatever the "done" button is there; I'm working from memory) and let the table load again. New columns should show up now.

Sounds buggy to me. If I SELECT * FROM TABLE, I'd expect new columns to be added in automatically, but using the approach above was the only way I got it working.
 
Joined
Aug 10, 2016
Messages
9
Reaction score
0
Points
0
HI

I keep adding new columns of data in my source external table, but it will not translate over to PowerPivot when I refresh. Are there any potential reasons the information might not be picking up.


Dear , check your table range after adding columns or rows.

Regards,
 
Top