Forum Discussion
Duplicate values while creating a copy table
Hi All,
I have a Table A in my power bi desktop with an incremental refresh. I created another Table B with incremental refresh with the same query as Table A (basically a copy table). The relationship and everything is an exact copy of table A. But I see the values in Table B are duplicated and somehow more than Table A. Any idea why this is happening?
I am duplicating the table because I want to keep some columns in table A and apply RLS to them different from table B.
3 Replies
alexa_0028 do you have the same IR setup done for Table B as Table A?
Hi, yes the IR policy is same between the tables and the column on which the IR is applied is of type date/time.
And my filtered expressions is like:
Table.SelectRows(TableB, each [date] >= RangeStart and [date] < RangeEnd)
alexa_0028 and you also configured the incremental refresh on Table B similar to Table A, correct?
