Appending data

[Anonymous]

Hello!

I am setting up some nice visualizations for an Excel Data file.

Every week, I will receive new data.  

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?

Thanks,

Erin

[Anonymous]

HI @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]

Hello!

Can you combine the data from 2 pbix sets, please?

Thanks.

[Anonymous]

Hi @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

[amitchandak]

@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/

[Ashish_Mathur]

Hi,

See this video - https://www.youtube.com/watch?v=yL11ugShdrk.

Hope this helps.