Not being able to merge two tables in Power Query

[Anonymous]

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 some other table using "Merge Queries". I am trying to merge "Dim_Date" with "Dates_Cross_Join" but not being able to do so due to the warning sign and "No Preview is available". Image attached for reference.

But when I try with "Merge queries as New", it works fine. 

Your help would be greatly appreciated.

Thanks in advance!

[Greg_Deckler · Accepted solution]

@Anonymous Perhaps there is some sort of dependency between those two queries? Does one refer to the other?

[leyes]

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

[Greg_Deckler · Accepted solution]

@Anonymous Perhaps there is some sort of dependency between those two queries? Does one refer to the other?

[Anonymous]

@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?

[Greg_Deckler · Accepted solution]

@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.