This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Learn More

Remove From My Forums

Power Pivot Import Column

Question
0

Sign in to vote

I just started learning how to create dashboards on Excel. I used Power Pivot to pull the data from an Access database query. I noticed I was missing a column that I needed, so I updated the the query in Access. I tried refreshing the database in Power Pivot, but the new column won't show up. How can I import this newly added column into Power Pivot?

Thanks,

Friday, February 17, 2017 7:41 PM

All replies

0

Sign in to vote
Open PowerPivot, Design tab>Table Properties> the window that appear you should make sure that "Source" is selected under "column names from">you should see your column check box unchecked>check it and Save.

Regards, AK
- Edited by Abdallah El Kamel Friday, February 17, 2017 9:25 PM
- Proposed as answer by Yuki SunMicrosoft contingent staff Monday, February 20, 2017 8:56 AM
Friday, February 17, 2017 9:23 PM
0

Sign in to vote
Hi JV88,

Have you checked if the above reply provided by Akbode7 can resolve your issue?

Besides, for more information about making changes to an existing data source in Power Pivot, you may also refer to the article below:

https://support.office.com/en-us/article/Make-changes-to-an-existing-data-source-in-Power-Pivot-9cb508d3-1a83-4d83-a944-700ce41332b6

Hope this can be helpful.

Best regards,
Yuki Sun
Please remember to mark the replies as answers if they helped.

If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
- Proposed as answer by Yuki SunMicrosoft contingent staff Monday, February 27, 2017 9:48 AM
Monday, February 20, 2017 8:59 AM