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,
Anyway, the reason I want to do that way is to build up my data history from day 1. Overtime the table will contain all daily data where Query A is a function of getting snapshot data. Cheers.
I don't think Append Query option will help to build up history data in Power BI. Here is a similar thread about storing historical data, and there are some workaround mentioned there, could you go to check if it helps in your scenario? :smileyhappy:
Regards
inzaghi1230
9 years agoFrequent Visitor
Thanks you very much indeed v-ljerr-msft. I will look into the solution! Cheers.