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
     
selimovd's avatar
selimovd
Most 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