+ Reply to Thread
Results 1 to 4 of 4

Power Pivot SQL Data Import - How to update import filter

  1. #1
    Registered User
    Join Date
    09-24-2013
    Location
    Twin Cities, MN
    MS-Off Ver
    Excel 2010
    Posts
    91

    Power Pivot SQL Data Import - How to update import filter

    I have a SQL database of finacial information that I import data from. The first item in each record in the table is a DataSetID. The table has many data sets and I do not want them all, so I chose only those that I needed to import. Now however a new data set has been added that I also want to import in addition to those currently being imported. How can I add the new DataSetID to my existing list? When I "open the existing connection" none of the filtering information is there. It must be somewhere since a data refresh only returns the DataSetID's that I originally chose.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Power Pivot SQL Data Import - How to update import filter

    select the table in the powerpivot window, choose table properties on the Design tab and then alter the filter as needed
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    09-24-2013
    Location
    Twin Cities, MN
    MS-Off Ver
    Excel 2010
    Posts
    91

    Re: Power Pivot SQL Data Import - How to update import filter

    That worked. Thanks so much, don't know why I didn't think to look there!

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Power Pivot SQL Data Import - How to update import filter

    they didn't really make it obvious :-)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Filter Data From One Workbook and Import in Another
    By dhribar in forum Excel General
    Replies: 1
    Last Post: 07-29-2011, 04:07 PM
  2. Import SQL data, edit, then update back to SQL
    By ddlaz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2011, 12:31 AM
  3. Import and Filter Data from Access
    By RunrChic01 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-27-2008, 10:31 PM
  4. Data Import and Filter
    By Josh O. in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-15-2005, 03:05 PM
  5. Import filter and update master
    By Mikeice in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-03-2005, 09:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1