Forum Discussion
Append
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
Most Valuable ProfessionalHey Anonymous ,
if you want to append it in Power Query you have to import it first. After appending it, you can disable the load of the original Excel table. Like this the original Excel table will not be loaded to the data model.
If you don't want to do that in Power Query you have to do it in the data source where your table is. Like in SQL Server, mySQL, Sharepoint and so on.
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
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicThank you so much! selimovd