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

[IKKIExcel]

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

 

[Matt Allington]

There is no incremental refresh unless you are using Power BI premium. When you refresh power query, the original table of data is removed and a new table is loaded. If you have new CSV files containing new data, you should simply use the file combine feature Combine CSV Files with Power Query - Excelerator BI