Power BI中查询生成的重复表刷新问题咨询：刷新源查询时重复表是否会同步刷新？

Hey there! Let’s break down exactly how this works—it all depends on how you created that duplicate table in Power Query:

1. 独立复制的查询（逻辑静态副本） #

If you right-click your source query → Copy, then paste to make a new query, this duplicate is an independent standalone copy. Here’s what that means:

• When you refresh your dataset, this duplicate query will pull the latest data from the original data source (just like the source query does) — because its underlying steps still point to that source.
• But if you edit the logic of the source query (like adding a filter, renaming a column, or tweaking a transformation), this duplicate won’t automatically pick up those changes. It’ll stick with the exact steps it had when you copied it.

2. 引用查询（动态关联副本） #

If you right-click the source query → Reference to create your duplicate, this new query is directly linked to the source. This is the "live sync" scenario:

• Any updates to the source query’s data (from refreshing the original data source) will flow through to the reference query automatically when you refresh.
• Even if you modify the source query’s transformation steps, the reference query will use the updated source query as its starting point. If you added extra steps to the reference query (like additional filters), those will run on top of the refreshed source data.

Quick Recap #

• Copied queries: Share the same data source, but don’t sync with source query logic changes. They refresh their own data from the source, but stay locked to the original transformation steps.
• Referenced queries: Fully sync with the source query — both data updates and logic changes are reflected when you refresh.

内容的提问来源于stack exchange，提问作者Mateusz P