SOLVED

Append Data to Worksheet Data to Existing Table in DataModel

%3CLINGO-SUB%20id%3D%22lingo-sub-1487596%22%20slang%3D%22en-US%22%3EAppend%20Data%20to%20Worksheet%20Data%20to%20Existing%20Table%20in%20DataModel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1487596%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20take%20data%20from%20a%20worksheet%20range%20or%20table%20and%20append%20it%20to%20an%20existing%20table%20in%20an%20excel%20data%20model%3F%20Currently%20to%20only%20option%20I%20see%20available%20are%3A%3C%2FP%3E%3CP%3E1)%20write%20a%20VBA%20or%20R%20script%20to%20append%20the%20selected%20data%20to%20a%20CSV%20file%20and%20use%20this%20as%20a%20source%20for%20the%20data%20model%2C%20or%3C%2FP%3E%3CP%3E2)%20load%20the%20data%20into%20sql%20database%20via%20siss%20or%20other%20means.%20%26nbsp%3B%20The%20goal%20is%20to%20load%20this%26nbsp%3B%20data%20in%20the%20data%20model%20into%20power%20bi%20to%20update%20a%20dashboard.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThnak%2C%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1487596%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1488468%22%20slang%3D%22en-US%22%3ERe%3A%20Append%20Data%20to%20Worksheet%20Data%20to%20Existing%20Table%20in%20DataModel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1488468%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F709460%22%20target%3D%22_blank%22%3E%40King7son1%3C%2FA%3E%26nbsp%3BIt%20can%20be%20done%20by%20having%20a%20query%20append%20to%20itself%2C%20but%20you'll%20have%20to%20figure%20out%20a%20way%20to%20prevent%20it%20from%20appending%20new%20entries%20more%20than%20once%2C%20for%20example%20by%20deleting%20duplicates%20in%20the%20query.%20See%20attached%20example.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1489077%22%20slang%3D%22en-US%22%3ERe%3A%20Append%20Data%20to%20Worksheet%20Data%20to%20Existing%20Table%20in%20DataModel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1489077%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20Jan%20that%20worked%20perfectly!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

2 Replies
Best Response confirmed by King7son1 (New Contributor)
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.

@Jan Karel Pieterse 

 

Thank you Jan that worked perfectly!