How to update the datasource metadata?

Question

Hi,

I have created a powerpivot (2012) in Excel 2010 which uses an external sql server database as the datasource. Now, one of the database tables has got a new field which I want to use inside powerpivot. How do I update powerpivot to get the new field from one of my tables (without loosing my exisiting measures)?

Thanks
Thomas 

Answer 1

Hi,

you can try click on the refresh button which is available inside power pivot window.

==================================

Please mark as answer if helpful.

Answer 2

If 'Refresh' does not work, you can go into the 'Table Properties'. When you click 'Table Properties' you will see the updated column. Check the column. Once you check the column, the data will be loaded back in to the table. 

---

Words offer the means to meaning, and for those who will listen, the enunciation of truth - V for Vendetta.

Answer 3

In PowerPivot, go to Design tab and choose Existing Connections, then pick your "PowerPivot Data Connections" and choose Open, then select your table, and to Preview and Filter, check the new column you desire, click "OK".

---

-- This posting is provided "AS IS" with no warranties, and confers no rights