Why Merge/Append Queries option greyed out in Schema view?

[_Smrithi]

The tables in my Dataflow Gen2 are too large. So I always switch to Schema view. But the Merge/Append options are greyed out when we are in schema view. Is there a workaround to this without going to Data view? (Tables are too large)

[V-yubandi-msft]

Hi @_Smrithi ,

We noticed we haven't received a response from you yet, so we wanted to follow up and ensure the solution we provided addressed your issue. If you require any further assistance or have additional questions, please let us know.

Your feedback is valuable to us, and we look forward to hearing from you soon.

Thank You.

[V-yubandi-msft]

Hi @_Smrithi ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution we provided for your issue worked for you  or let us know if you need any further assistance?

Your feedback is important to us, Looking forward to your response. 

Thank You.

[V-yubandi-msft]

Hi @_Smrithi ,

we wanted to check in as we haven't heard back from you. Did our solution work for you? If you need any more help, please don't hesitate to ask. Your feedback is very important to us. We hope to hear from you soon.
Thank You.

[V-yubandi-msft]

Hi @_Smrithi ,

The answer provided by the @OwenAuger , is correct. In addition to their solution, here are a few more points that might help.

1. If your specified dataflow uses a Live Connection mode, ensure that the append query is supported, as it may not be in this mode.

2. Verify that the queries you want to merge or append are enabled for load. If a query has "Enable Load" set to false, it may not be available for merging or appending operations.

3. Ensure you have selected two columns to merge or append the queries.

Thanks to @OwenAuger  for their valuable input.

If my answer addressed your query, kindly mark it as the Accepted Solution to assist others.

I'd also be grateful for a 'Kudos' if you found my response useful!   

[OwenAuger · Accepted solution]

Hi @_Smrithi 

Interesting, I tested myself and I see the same thing, i.e. that when in Schema view, that Merge queries and Append queries options on the ribbon are greyed out.

However, it does appear that Merge queries and Append queries are available in the ellipsis or right-click menus within the diagram:

This is the only place I can find these function in the interface. The only other option would be to write the M code by hand.

Looks like it would be worth giving some feedback on the Schema view feature 😉