Recall from my earlier post we have created a connection to SQL Navision Database in my previous post.
PowerPivot Creating a Data Model in Excel 2013
I will be modifying same connection to include more tables to the Data model.
![PowerPivot-10](https://msdynamicsnavashwinitripathi.files.wordpress.com/2015/09/poverpivot-10.jpg)
Click on PowerPivot-> Manage.
From the PowerPivot Sheet click on Existing Connections.
This will open Connection Window Listing all available connection to PowerPivot for this Sheet.
Double Click the Connection in my case Nav2015DB_SQL_Connection.
![PowerPivot-6](https://msdynamicsnavashwinitripathi.files.wordpress.com/2015/09/poverpivot-6.jpg)
Select first option as we used in previous post and then Next for next Step.
![PowerPivot-11](https://msdynamicsnavashwinitripathi.files.wordpress.com/2015/09/poverpivot-11.jpg)
Select Item & Item Ledger Entry Tables and then Finish to import Data to the Sheet.
![PowerPivot-12](https://msdynamicsnavashwinitripathi.files.wordpress.com/2015/09/poverpivot-12.jpg)
On Success Click Close to return to Data Model Sheets.
![PowerPivot-13](https://msdynamicsnavashwinitripathi.files.wordpress.com/2015/09/poverpivot-13.jpg)
You will find two new sheets have been added to PowerPivot Sheet.
I will come up with more option on this topic in my next post, till then start practicing and stay tuned for more details & Updates on this topic.
[…] Adding more tables to the Data Model using Existing Connection – In PowerPivot […]
ReplyDelete[…] Adding more tables to the Data Model using Existing Connection – In PowerPivot […]
ReplyDelete[…] Adding more tables to the Data Model using Existing Connection – In PowerPivot […]
ReplyDelete[…] Adding more tables to the Data Model using Existing Connection – In PowerPivot […]
ReplyDelete[…] Adding more tables to the Data Model using Existing Connection – In PowerPivot […]
ReplyDelete[…] Adding more tables to the Data Model using Existing Connection – In PowerPivot […]
ReplyDelete