Forum Discussion
Solved
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 J...
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,
AFAIK if you are changing data at source, you cannot append to exisiting table in powerbi, you have to keep data at source.