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
dkay84_PowerBI's avatar
dkay84_PowerBI
Microsoft Employee
9 years ago

What is your rationale for appending Query A data into a blank table?  Why not just use Query A's table?  Have you created columns in Table B that match (at least in part) the columns from Query A?  If not, the append wont work.

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.