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
RahMan911's avatar
RahMan911
Frequent Visitor
8 years ago

There must be an error table referencing it. Delete the error table first

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 .