Add data to a table in the datamodel that was created using powerquery

IKKIExcel

New Member
Joined
Aug 29, 2020
Messages
1
Office Version
  1. 365
Hi friends,

Using powerquery I loaded to the data model a table containing certain data from a full year. I did this by importing a csv file containing the full year data and loading it only to the data model.

Now I would like to add data from one aditional month, without reloading againg the original csv field. I mean, I just want to add more data (from a new csv) over the existing one.

I know how to do the trick when the data is stored in normal excel tables but I don't know how to do it when the data is stored in the data model, because I can not create a query to the existing data in the data model to append it with the query pointing to the "new month" csv file.

Thanks in advance for your help
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Watch MrExcel Video

Forum statistics

Threads
1,114,109
Messages
5,545,991
Members
410,718
Latest member
ALM1GHTY
Top