Forum Discussion
Helper IDataflow - Append Queries is greyed out
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!
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.
1 Reply
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.