Forum Discussion

Kiruthiga's avatar
Kiruthiga
Icon for Helper I rankHelper I
1 year ago
Solved

Regarding circular reference while appending 2 tables in power query

Hello Friends,   I appreciate your time!! I am trying to append 2 tables but I am getting circular reference error:   let Source = Snowflake.Databases("cimaBBO.ku-west-1.snowflakecomputing.com",...
Need Help
  • Kiruthiga's avatar
    Kiruthiga
    1 year ago

    I think I got it.,the table 2 is referencing table1 during its formation.Now  I created the appeand as new and that fixed it!! 

     

    Thanks a lot!!

     

    Best,

    Kiruthiga

Deku's avatar
Deku
Icon for Super User rankSuper User
1 year ago

Not sure why circular reference without seeing the other table definition.

 

Are they both coming from snowflake? Would be best practice to perform the union there in a view