Forum Discussion
Avoiding a loop when appending data to a table - Dataflows
Hi, I currently have a process in Power Query in Excel that captures changes in the source data, which is then added to another reference table, which in turn is used to identify the changes in the s...
Hi stevehog23 ,
Please see if this document helps: Merging tables in Power BI dataflows with PRO subscription
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, I have Premium so the issue is not that I can't save a calculated table, it's that I can't work out how to make that table updateable each time the flow is refreshed.
Ideally I'd like to be able to specify the sequence in which steps in the queries are applied, i.e. step 1 de-dupe Table B against Table A, then step 2 append the rows that remain in Table B to the bottom of Table A, ready for the next refresh. That doesn't seem to be possible though?