Forum Discussion

lee_a's avatar
lee_a
Frequent Visitor
8 years ago

Cannot Delete Query/Parameter/Table

Hi,    I have this query entry that I cannot delete. This query was originally belonged to a number of queries created when entering a local folder of files as a new source. The query was a paramet...
Need Help
lee_a's avatar
lee_a
Frequent Visitor
8 years ago

Hi Rahman

 

I don't have any error tables remaining in my data model. Even the Table/queries that were originally related to this item have all been deleted successfully. 

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi lee_a,

 

The query may also be referenced in methods in the Advanced Editor. You could try to look for the "Sample File Parameter2 (2)" in the advanced Editor. 

 

Best Regards,

Cherry

  • lee_a's avatar
    lee_a
    Frequent Visitor
    8 years ago

    Hi Cherry, 

     

    "Sample File Parameter2 (2)" refers to a query that has been deleted or at least renamed.

     

    I've reviewed all my PowerQuery coding in advanced coding for every single one of my other queries and "Sample File Parameter2 (2)" does not exist. 

     

    I've renamed the query to be deleted and changed the underlying PowerQuery coding in multiple different ways and none of my other queries have broken. 

     

    Could you explain a little bit more about what you mean by "Methods"? 

     

    I think this is a bug... I have a query which is apparenlty being referenced somewhere and the references view doesn't show this apparently relationship.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      This is interesting, but without the table being referenced anywhere, this error wont occur .

      • lee_a's avatar
        lee_a
        Frequent Visitor
        8 years ago

        It's possible that I've missed this "Sample File Parameter2 (2)" text in my advanced editor coding in my queries but I've double checked multiple times. Let's say I am in fact overlooking this or not looking in the right place, if the references editor was working properly, wouldn't I see where the query I'm trying to delete is being referenced? Further, if I changed this query from a table, to a parameter, to a function, added text, etc etc, wouldn't the supposed query/table that references it break and thus direct me to where this reference is so I can delete it?

         

        Something's not working.

         

        Maybe we can get better debug tools...