Forum Discussion

inzaghi1230's avatar
inzaghi1230
Frequent Visitor
9 years ago

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...
Need Help
inzaghi1230's avatar
inzaghi1230
Frequent Visitor
9 years ago

Hi, I thought I have replied but seemed disappeared. 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.

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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's avatar
    inzaghi1230
    Frequent Visitor
    9 years ago

    Thanks you very much indeed v-ljerr-msft. I will look into the solution! Cheers.