Forum Discussion

csteves's avatar
csteves
Frequent Visitor
9 years ago
Solved

Append Data Merge Data in Power BI Desktop

Hello,

 

I am trying to run an append query for a mass amount of data from multiple tables to one single table. For example. I have a file with only headers that I'd like to occupy with other tables including retail data, inventory data, and other. This will be a fluid amount of rows changing each time I run the report. 

 

 

Can someone point me in the right direction for this? Essentially, I'm wanting to make an append query similar to Access database's append query.

  • Hi csteves,

     

    Have you resolved your issue?  There is an article here, which describes the detailed steps by giving example, please review it.

    Best Regards,
    Angelia

3 Replies

  • ImkeF's avatar
    ImkeF
    Community Champion

    In the query-editor: Home -> Combine -> Append Queries

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee

        Hi csteves,

         

        Have you resolved your issue?  There is an article here, which describes the detailed steps by giving example, please review it.

        Best Regards,
        Angelia