Forum Discussion
Not being able to merge two tables in Power Query
Hey All, I am new to Power BI and struggling with merging queries. Could someone please tell me why I am getting warning sign against so many tables while I am trying to merge "Dim_Date" with so...
Anonymous Perhaps there is some sort of dependency between those two queries? Does one refer to the other?
- Anonymous I would say 100% that is the issue and why it works if you merge new, because with merge new it will load the queries in the right order , load Dim_Date and then Shipment and then Dates_Cross_Join and then the new merge query. Otherwise, you have effectively created a circular reference and it is not going to like that.
Greg_Deckler Hey.. "Dates_Cross_Join" is a reference of "Shipment" table and "Shipment" table is a merge of "Dim_Date" and another table.
Could this be a reason behind the problem?
Anonymous I would say 100% that is the issue and why it works if you merge new, because with merge new it will load the queries in the right order , load Dim_Date and then Shipment and then Dates_Cross_Join and then the new merge query. Otherwise, you have effectively created a circular reference and it is not going to like that.