Can I automate appending files from a folder?

[Shri_mukherjee]

Can I automate the process of appending excel files in a folder on Power Bi? The requirement is to make a single connection to the folder from Power BI and whenever there is a refresh, Power Bi will automatically append the files contained in the folder. Is it possible? 

[pabeader]

Are you trying to create filec.xlsx from filea.xlsx appended with fileb.xlsx?  Or are you trying to include new data from fileb.xlsx into the existing data model from filea.xlsx?

[v-evelk]

Hello,

I suppose that you can try to implement some connector that will work with a file server but you should ask about it in an appropriate thread as that or that one.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com