CODEWITHSUNDEEP
powerbipowerquery
variable
variable

Reputation: 9664

Why does table refresh when it is part of merge even when the `include is report refresh` is disabled on the source table (source of merge)?

I have 2 tables in Power query.

  1. Sales
  2. Rate

I have merged Rate into Sales and pulled in Rate.percentage column into the Sales table.

Then I unchecked the include in report refresh option on Rate table. My intention is that the Rate table should never refresh and Sales table merge to the Rate table should always consider the value as of the time of 1st refresh that I do when performing the 1st data load.

To test this I updated some rate percentage values in the Rate table in the db, and notice that in the report visual the values that come from the Rate table still shows old value (which I expected). However, the Rate.percentage column that is part of the Sales table (due to merge) shows updated values. Is this expected? and how to prevent this?

I also tried unchecking the enable load option. With this the Rate table cannot be used inn visual (expected), but the rate.percentage on the Sales table visuals show updated Rates (when I change the values in the db and hit refresh).

Upvotes: 1

Views: 1002

Answers (1)

davidebacci
davidebacci

Reputation: 30219

This is just the way PQ works. It doesn't store any data. If you have a table A that you are refreshing which is merging in values from Table B which you have told not to refresh, then PQ wouldn't be able to proceed. It needs to restream that data from Table B despite your instruction not to refresh so that it can refresh Table A.

That instruction to not refresh Table B only works if the table is used in isolation and not used in other queries.

Upvotes: 1

Related Questions