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","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

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

4 Replies

  • 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

  • Kiruthiga's avatar
    Kiruthiga
    Icon for Helper I rankHelper I
    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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