Forum Discussion
Append Data to Worksheet Data to Existing Table in DataModel
Hello
Is there a way to take data from a worksheet range or table and append it to an existing table in an excel data model? Currently to only option I see available are:
1) write a VBA or R script to append the selected data to a CSV file and use this as a source for the data model, or
2) load the data into sql database via siss or other means. The goal is to load this data in the data model into power bi to update a dashboard.
Thnak,
Thanks in advance for your help.
King7son1 It can be done by having a query append to itself, but you'll have to figure out a way to prevent it from appending new entries more than once, for example by deleting duplicates in the query. See attached example.
2 Replies
King7son1 It can be done by having a query append to itself, but you'll have to figure out a way to prevent it from appending new entries more than once, for example by deleting duplicates in the query. See attached example.
