Forum Discussion
Solved
Table append issue
Hi All I have Table 1 source from share point and did some additional steps like adding additional columns, Then I extracted Table 2 by using distinct option on Table 2. Now if I tried to ...
without duplicating the table 1, create the table 2 from the sharepoint source and apply all the required calculated formula( you can replicate the same calculated steps as in table 1), and now the append will work without any interuption.
Hi Kesavaraman,
can you please try below one?
Right-click Table 1 in Power Query and choose "Reference" (not "Duplicate"), then rename it to NewTable to ensure independence from Table 1.
Apply the Distinct operation on NewTable to create Table 2, preventing a direct dependency on Table 1.
Append Table 2 to Table 1, ensuring that Table 2 is sourced from NewTable, thus eliminating the circular reference.
Thanks.
Hi I have tried the same but still facing the error