Forum Discussion

KimStahl94's avatar
KimStahl94
Helper I
4 years ago

Strange error pattern "Query references other queries or steps, so it may not directly access ... "

Hello,   I know that there are already some requests on this topic, but everything I have read and tried did not work. So please here me out.   I am querying some Excel files stored on SharePoint...
Need Help
  • KimStahl94's avatar
    KimStahl94
    Helper I
    4 years ago

    Hi Anonymous ,

    thank you for your reply. I have tried to find the error step. It is always the last step of the referenced query. When I add another step to the query, it references the added step. So I suspect that the error is not caused by the step itself. 

     

    I also implemented a staging area as you can see above in my linked query dependencies. So every merged query (#"Wertenachweis Summen", #"Wertenachweis gesamt", #"Kontenzuordnung") is also not quering its data from SharePoint but from another table, that is connected to SharePoint.

    Below I attached a screenshot and here you can find the code of the referenced query.

     

     

    Regards

    KS