Forum Discussion
Basic table dynamics, append table inside PB
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
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:
Regards,
2 Replies
AFAIK if you are changing data at source, you cannot append to exisiting table in powerbi, you have to keep data at source.
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:
Regards,
