Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Append

Hi All, I have a table and I need to append an excel file to it. I do not want to import the data and then append. Instead, I want the excel file to be appended directly to the table. Is that poss...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Anonymous ,

     

    sure. In Power Query click on the Query of the Excel that you don't want to load to the data model and unselect "Enable load":

     

    Afterwards the Excel will still be refreshed and used for the other table, but this specific table from the Excel file will not appear in the Data Model.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi selimovd ,

 

Thank you for your response.

Can you please tell me on how to disable the load of original excel table.

I do not want the appended tables to be seen in the data model.

Thank you!

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey Anonymous ,

 

sure. In Power Query click on the Query of the Excel that you don't want to load to the data model and unselect "Enable load":

 

Afterwards the Excel will still be refreshed and used for the other table, but this specific table from the Excel file will not appear in the Data Model.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you so much! selimovd