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.
As others commented below, maybe there's a dependency between those two queries. You can turn this around using DAX OR...
You can right click on Dim_Date and press "Reference". It will create another query called "Dim_Date (2)" and you com merge it with "Dates_Cross_Join". Doing this, you have to start working on "Dim_Date (2)" besides "Dim_Date".
The difference between 'duplicate' and 'reference': Solved: Difference between Reference and Duplicate - Microsoft Power BI Community