Basic table dynamics, append table inside PB

[MarceloSouza]

I'm going to receive a monthly dynamic table, I need to record the data from the previous months into PowerBI.
Example:
dynamic table : (The records are erased every month)
Jan17 aaa
Jan17 bbb
Jan17 ccc

Table on PowerBI
Jan17 aaa
Jan17 bbb
Jan17 ccc

In the next month I update the data of the same table

dynamic table :
Feb17 mmm
Feb17 nnn

My table in Power BI should be with the information of every month

Table on PowerBI
Jan17 aaa
Jan17 bbb
Jan17 ccc
Feb17 mmm
Feb17 nnn

thank you

[v-sihou-msft · Accepted solution]

@MarceloSouza

There's no direct way to append a dynamic table into one dataset. You can extract the table into a file in a folder once your update the table. This can be done in DAX studio. Then you can get data from folder in Power BI Desktop.

Another way is using R script to write the dataset into a file, you just need to add "append=TRUE" in write() function. The get data from that file. See: How to create a Load History or Load Log in Power Query or Power BI

Please refer to a similar thread below:

https://community.powerbi.com/t5/Desktop/Save-old-and-append-updated-data-into-an-additional-table/t...

Regards,

[parry2k]

AFAIK if you are changing data at source, you cannot append to exisiting table in powerbi, you have to keep data at source.