Jun 24 2020 02:32 PM
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.
Jun 25 2020 02:18 AM
Solution@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.
Jun 25 2020 06:54 AM
Jun 25 2020 02:18 AM
Solution@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.