quarta-feira, 11 de abril de 2012 16:21
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)?
Todas as Respostas
quinta-feira, 12 de abril de 2012 10:00
you can try click on the refresh button which is available inside power pivot window.
Please mark as answer if helpful.
quinta-feira, 12 de abril de 2012 21:22
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.
quinta-feira, 12 de abril de 2012 23:09In 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