Results 1 to 9 of 9

Thread: Duplicated tables, cant make changes to original, reference error

  1. #1
    Seeker ilcaa's Avatar
    Join Date
    Jun 2018
    Posts
    10
    Articles
    0
    Excel Version
    2016

    Duplicated tables, cant make changes to original, reference error



    Register for a FREE account, and/
    or Log in to avoid these ads!

    i duplicated some tables and also created merge from 2 other tables... I did these steps to move certain values and place them in their own tables, but once I have the tables like I need them, I would like to remove the "helper tables", it seems I cant cause the new tables, merges are 'referencing' those original tables...

    I thought i could 'duplicate' a table and they would stand on their own, it seems that not the case... anyway to work around the referencing back to originals? I thought that is what the "reference" option was there for..

    hope i made sens

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,237
    Articles
    0
    Excel Version
    Office 365 Subscription
    When you duplicated the table, how did you do it? Did you duplicate the query? I would just use basic copy and paste for this.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Seeker ilcaa's Avatar
    Join Date
    Jun 2018
    Posts
    10
    Articles
    0
    Excel Version
    2016
    within PQ editor, in the queries pane, i right clicked the query (table) and selected 'duplicate', created a merged table, if i try to delete the duplicate it cant "cant delete query, query 'xxx' referencing this query" even if i try and change a column name it ruins the merged table.... i thought i could avoid this referencing... is there a better way? thanks
    Last edited by ilcaa; 2018-06-17 at 01:57 AM.

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,237
    Articles
    0
    Excel Version
    Office 365 Subscription
    Difficult to say with any certainty without seeing the file - I'm not entirely clear how you've set it up. Please attach the file here.
    Ali
    Enthusiastic self-taught user of MS Excel!

  5. #5
    Seeker ilcaa's Avatar
    Join Date
    Jun 2018
    Posts
    10
    Articles
    0
    Excel Version
    2016
    thanks Ali, so you are saying this is not normal behavior? that you can duplicate a table and it should not reference the original table (meaning you can continue to edit the original table without causing errors to duplicated table) ?

  6. #6
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,237
    Articles
    0
    Excel Version
    Office 365 Subscription
    No, what I am saying, I am afraid, is that I can't quite work out what you have done based on your description, which is why I would like to see the workbook.
    Ali
    Enthusiastic self-taught user of MS Excel!

  7. #7
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,237
    Articles
    0
    Excel Version
    Office 365 Subscription
    If you could attach the workbook, I'll take a look.
    Ali
    Enthusiastic self-taught user of MS Excel!

  8. #8
    Seeker ilcaa's Avatar
    Join Date
    Jun 2018
    Posts
    10
    Articles
    0
    Excel Version
    2016
    i am trying to find the original workbook pbix file but cant, i am trying to replicate the error but i am now able to duplicate queries in PB editor, make changes to both tables, delete the original one, etc

    problem solved. maybe my PQ editor heard i was talking to you and straighten up (or maybe i click reference) probably the latter. thanks again

  9. #9
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,237
    Articles
    0
    Excel Version
    Office 365 Subscription
    A .pbix file is for Power BI, not Power Query, so I would not have been able to help, anyway.
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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