Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hidden Query Keeps Coming Back

I keep hiding a query, and after a few seconds, it unhides itself. What could be causing this behavior?   Context:   I have multiple identical queries, all the same data from the same source, tha...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
10 years ago

Anonymous

I have tested it on my local environment (Version: 2.36.4434.362 64-bit (June 2016)), we cannot reproduce this issue. I tried both Merge Queries and Append Queries, in your scenario, do you used Merge Queries or Append Queries?

 

For the number of tables that can be combined in one operation, I don't think there is such a limitation, you can append three or more tables.

 

Regards,

Charlie Liao

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Charlie,

     

    Thank you for responding. We are using Append Queries, but we've run into issues when the number of queries reaches a high enough number in a single operation (I think at around 14 it stopped working). What's the maximum number of queries you were able to combine?

     

    However, that isn't my primary question. I was just hoping someone here might be aware of any limitations in Append Queries. My question is why my hidden Query won't stay hidden. How can I diagnose and fix this issue?