Forum Discussion
How does Append Queries work under the hood?
I have 3 tables, namely data_2020, data_2021, and data_2022 (all using DirectQuery), which are stored in a cloud server because of how large the datasets are. If I Append Queries as New these three t...
Read about Query folding. Use Performance Analyzer and/or DAX Studio to check the query that is actually run when you apply your filters.