Results 1 to 3 of 3

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

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

  3. #3

    HI

    Quote Originally Posted by nvcc_ite140galindo View Post
    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,

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •