Forum Discussion

Sibrulotte's avatar
Sibrulotte
Icon for Helper IV rankHelper IV
6 years ago

Power pivot table, can't be found in power query

Hi, 

I have an error message saying Query XYZ cannot be found when I refresh all. This query is definitly not in the query list on the right menu in excel, not in the left menu in power query BUT, it can be found in power pivot model. When I try to supress it from power pivot model, I get an error message saying the query was created using Power Query, to suppress it from there.

 

 

What the deuce!?!?

Need Help

7 Replies

  • Jimmy801's avatar
    Jimmy801
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hello

    so if Power Query is asking for a query, then in the M-Code is somewhere calling this query.

    Could you please post the file?

    Jimmy

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Sibrulotte, 

    I can't reproduce this problem in my environment, so if possible, could you please inform me more detailed information(such as your sample data or file)? Then I could test this in my environment. In addition, you also could could try to check whether there is query which refer to query XYZ, you could check this in advanced editor to see whether exist XYZ.

    Please do mask sensitive data before uploading.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Sibrulotte's avatar
      Sibrulotte
      Icon for Helper IV rankHelper IV
      6 years ago
       
       
       

      Trying to post a .png with screenshots...

      this board is not having any of it.

       

      There you go, got it.

      Also, it's all in french, but it's all standard error messages 😉