Welcome, Guest
Username Password: Remember me
Forgot your password? Forgot your username? Create an account
Please ask here your questions related to DAX and PowerPivot for Excel or PowerPivot for SharePoint. To post your question or reply you need to login first!
Reply Topic
New Topic
  • Page:
  • 1

TOPIC: how to add another SQL server table 2 PowerPivot

how to add another SQL server table 2 PowerPivot 1 year, 1 month ago #406

  • Mel Suarez
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
Here's a basic question. I have an Excel spreadsheet with a connection to a PowerPivot SQL Server data connection. I have about a dozen tables in the PP connection. How do I ADD another table to my PP connection?
Reply Quote

Re: how to add another SQL server table 2 PowerPivot 1 year, 1 month ago #407

  • admin
  • OFFLINE
  • Administrator
  • Posts: 5
  • Karma: 0
In PowerPivot window go to Design tab then click on "Existing Connections" button, select your connection to SQL Server and click "Open".
Reply Quote

Re: how to add another SQL server table 2 PowerPivot 1 year, 1 month ago #408

  • Mel Suarez
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
Thanks Admin. That did the trick. Got to know the menus quite well looking for the answer. I'm slowly becoming a PowerPivot user. Looks like a great way to test cube design using an independent approach.
Reply Quote

Re: how to add another SQL server table 2 PowerPivot 1 year, 1 month ago #409

  • admin
  • OFFLINE
  • Administrator
  • Posts: 5
  • Karma: 0
Mel,

On the top left PowerPivot window corner there is also a small icone with arrow down. Click on it and choose "Switch to Advanced Mode". This will show you another tab where you can define perspectives and more properties for tables (mostly for PowerViewer".
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
PowerPivot and DAX forums
Main Forum
PowerPivot and DAX forum
Moderators: VidasMatelis, dgosbell
Powered by Kunena
Time to create page: 0.16 seconds
 

Pyramid+PowerPivot