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

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Watch MrExcel Video

Forum statistics

Threads
1,113,823
Messages
5,544,533
Members
410,617
Latest member
niayuliawati
Top