Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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,
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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |