Dataflow - Append Queries is greyed out

[csrapp96]

Hi PBI Community,

Up until this point of using PBI, I've been able to troubleshoot based off past questions and online resources.

I have run into a new issue that I have been unable to find a solution to.

I have a series of dataflows and append queries in there. As of this week, I go into the dataflows and cannot "append" queries as the button is greyed out at all times.

I am not sure what happened but any help is greatly appreciated. The workaround I've been doing is duplicating past appends and changing the source data to what I need to. 

Thank you!

[v-yetao1-msft · Accepted solution]

Hi @csrapp96 

Is it the specified dataflow or all dataflows do not support Append Queries ? If is the specified dataflow , you need to check if your datasource is Live connection mode, because append query is not supported in this mode .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.