Problem with Table Import Wizard

[Average Dude]

I’m working in PowerPivot 2013. I used the Table Import Wizard to pull in the original data sets I needed. The Table Import Wizard was nice because I could drag and drop the data sets into the table. The problem I am having is that I need to add some additional data sets, but I can’t get back to the Table Import Wizard I originally used to drag and drop my data sets in. I can get to the Table Import Wizard, but I no longer have the ability to drag and drop my data sets in…instead it wants to me write the logic using text. Can anyone tell me how to get the Table Import Wizard to allow me to drag and drop my datasets in?


Note to get to the Table Import Wizard from the Design tab of PowerPivot, I click on Table Properties>Design

Any help would be much appreciated!

 

[scottsen]

Seems like you are talking about two things:
1) Table properties let's you modify one table. If you "Switch to" the Query Editor and party on the text... game over. There is no way built in way to get back to "Table Preview" mode.
2) Table import... you should still be able to do. Drop "Existing Connections", double click your database, keep "select from list" selected, click Next... and bring in more tables.

 

[Average Dude]

Not sure I follow. I only have one query. I need to import additional columns to the query. I want to use the Table Import Wizard to drag and drop additional columns into the query, but the Table Import Wizard is requiring me to type everything out in text format instead of giving me the drag/drop option I had when I originally created the query. Does that make sense?

 

[scottsen]

On the table properties, there is a drop down "Switch To". It is currently set to "Query Editor". Can it be switched back to "Table Preview" ?

If it it gray, you don't have a lot of choices. 1 would be... delete the table and re-import it. Be sure to copy any measures and re-create relationships.