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
    Icon for Community Champion rankCommunity Champion

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

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Icon for Microsoft Employee rankMicrosoft 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