Appending data

Question

Hello!&nbsp;I am setting up some nice visualizations for an Excel Data file.&nbsp;Every week, I will receive new data.&nbsp;&nbsp;&nbsp;Is there a way to append the new data onto the existing data, such that I do not have to re-create my visualizations, please?&nbsp;Thanks,Erin&nbsp;

ashish_mathur · Answer

Hi,
See this video -&nbsp;https://www.youtube.com/watch?v=yL11ugShdrk.
Hope this helps.

amitchandak · Answer

Anonymous , refer
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
https://insightsoftware.com/blog/power-bi-load-data-from-folder/
https://powerbi.tips/2016/08/load-multiple-excel-xlsx-files/

anonymous · Answer

HI&nbsp;Anonymous,
IF these files have the same data structure you can use a folder connector to get the table with file lists, then you can use table.combine function with excel connector to analyze and combine these files.Regards,
Xiaoxin Sheng

anonymous · Answer

Hello!&nbsp;Can you combine the data from 2 pbix sets, please?&nbsp;Thanks.&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous,
Nope, you can't do combine on pbix files. Power bi not able to directly analytics pbix files to extract their datasets. (you can open the query edit on these pbix files and copy the M query codes to new pbix query editor to create new query tables)
Regards,
Xiaoxin Sheng

Forum Discussion

Appending data

5 Replies

Related content

Appending Data

Dataflow - Append

Append Queries 3 different data sources

Unpivot data before expand/append

Append Table action in Data pipeline duplicates all data rows instead of appending the new rows