+ Reply to Thread
Results 1 to 6 of 6

Duplicate query not updating

  1. #1
    Registered User
    Join Date
    02-11-2021
    Location
    Scotland
    MS-Off Ver
    Office 365
    Posts
    8

    Duplicate query not updating

    Hi there,

    I have connected to SQL to get a table of around 1000 rows.

    I then used PowerQuery to duplicate the source data in to 10 queries and filtered each so I can have 10 tabs in Excel showing relevant data.

    However, when I make a change to the SQL database, only the initial table is updated.

    Is there a way in which all versions of the source data can be updated when a refresh is performed?

    Any help with this is greatly appreciated.

    Thanks,
    Greg
    Last edited by gregwinter; 04-13-2021 at 07:36 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,330

    Re: Duplicate query not updating

    They should all update if you refresh all ...

    What settings have you used for the 10 sub-queries?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    02-11-2021
    Location
    Scotland
    MS-Off Ver
    Office 365
    Posts
    8

    Re: Duplicate query not updating

    I also expected them to update but from testing only the initial table updates.

    I am unaware of applying any settings to the sub-queries.

    I right-clicked the main query -> Duplicate -> Renamed, then filtered a single column within the table.

    The above steps are the same for all 10 sub-queries.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,330

    Re: Duplicate query not updating

    Right-click - properties - what settings have you there?

    There is no reason why they should not update if you've used the default settings.

    Can't really say anything more without seeing a sample.

  5. #5
    Registered User
    Join Date
    02-11-2021
    Location
    Scotland
    MS-Off Ver
    Office 365
    Posts
    8

    Re: Duplicate query not updating

    Yeah all sub-queries are default with the following options checked:

    - Enable background refresh
    - Refresh this connection on Refresh All

    Thanks to your affirmations, I have realised the mistake must have been due to the queries I have written rather than connection issues.
    The issue was due to changing the original query after copying an older version of it... DOH!!

    I appreciate your time and thanks for the help!

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,330

    Re: Duplicate query not updating

    Ah, yes - that would make a difference. I tend to use reference rather than Duplicate wherever possible.

+ 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. updating a power query
    By breathin in forum Excel General
    Replies: 2
    Last Post: 09-11-2020, 09:29 AM
  2. Query's keep updating when they dont need too!
    By JimmyWilliams in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-13-2020, 06:15 AM
  3. Power Query: Updating a query based on changing tables
    By cheesehead101 in forum Excel General
    Replies: 1
    Last Post: 12-16-2019, 06:54 PM
  4. Updating ODBC query with VBA
    By codemancode in forum Access Tables & Databases
    Replies: 1
    Last Post: 05-02-2018, 03:45 PM
  5. Microsoft Query Updating
    By Jacobg38 in forum Excel General
    Replies: 2
    Last Post: 01-09-2017, 02:10 PM
  6. Add something to an updating query table
    By ExcelFailure in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-02-2013, 03:42 AM
  7. updating query.
    By funkymonkUK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2006, 06:09 PM

Tags for this Thread

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