Regarding circular reference while appending 2 tables in power query

[Kiruthiga]

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","dev_power_bi_wh"),
DEV_BBO_DB_Database = Source{[Name="DEV_BBO_DB",Kind="Database"]}[Data],
sights_Schema = DEV_BBO_DB_Database{[Name="sights",Kind="Schema"]}[Data],
TRANS_STORE_UPC_FACT_SS_Table = sights_Schema{[Name="TRANS_STORE_UPC_FACT_SS",Kind="Table"]}[Data],
#"Appended Query" = Table.Combine({TRANS_STORE_UPC_FACT_SS_Table, BRIDGE_KEY_SS})
in
#"Appended Query"

Kindly suggest!

Appreciate your time!!

Thank you!

Best,

Kiruthiga

[v-pgoloju]

Hi @Kiruthiga,

Thank you for reaching out to the Microsoft Fabric Forum Community.

Also, a special thanks to @Deku  for the quick and helpful response.

Just following up to check if the solution shared by our Super User helped resolve your issue. If you're still facing difficulties or need further assistance, please let us know — we’re here to help!

If the response addressed your query, we kindly request you to mark it as Accepted Solution and click Yes if you found it helpful. This supports others in the community as well.

Best regards,

Prasanna Kumar

[Kiruthiga · Accepted solution]

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

[v-pgoloju]

Hi @Kiruthiga,

Great to hear that it's working as expected on your end! Could you please share the solution? It would be really helpful for others in the community who might be facing similar issues and can address them quickly. Also, I would suggest accepting your approach as the solution so that it can benefit others as well.

Thanks & Regards,

Prasanna Kumar

[Deku]

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