Forum Discussion
inzaghi1230
9 years agoFrequent Visitor
Append query doesn't work
I am having problem with my Append Query. In the Power BI desktop Query Editor, we have 2 append options which are Append Queries and Append Queries New. I simply want to Append all data from Que...
v-ljerr-msft
9 years agoMicrosoft Employee
Hi inzaghi1230,
I simply want to Append all data from Query A into table B which is empty. I suppose I only need to make a new step in my Query A to use "Append Queries", and in the pop up box asking for "Table to append", I should put in table B.
If you want to append all data from Query A into table B, you should make a new step in your table B instead of Query A, and use "Append Queries", and in the pop up box asking for "Table to append", you should put in Query A, then it should work if both Query A and table B have the same structures(columns).:smileyhappy:
Regards
- inzaghi12309 years agoFrequent Visitor