Forum Discussion
Adding Rows to a Table from Another Table
Nope, I guess with some R code this can be done but I don't think PowerBI is used to write back. You have to work on database end to take care of this.
I have the account table and don't have the account activity table.
I was hoping to create an account activity table from the data in the account table.
Not sure how that is even possible, if your data model doesn't have the data, I don't htink PowerBI can generate data. Think logically how PowerBI will now what was the previous friendshiplevel and when it was changed, may be I'm missing something here.
You're absolutely right and I understand that part.
My assumption was that since the data refreshes on a daily basis in Power BI, there can be a validation that checks if the LastModifiedDate for an account in the Account table is greater than the ModifiedDate for the same account in the Account Activity table. If it's not, then it adds the account data from the Account table to the Account Activity table as a new row.
Is that possible in Power BI?
Nope, I guess with some R code this can be done but I don't think PowerBI is used to write back. You have to work on database end to take care of this.
Thank you for letting me know. I appreciate your help!