Updating appended query with sharepoint files

[jgojani]

Is it possible to automatically update my appended query using new files uploaded into a sharepoint folder?

For instance, I have a sharepoint folder that gets updated monthly with a excel file. The only difference in the name of the files are the dates and the data in the files inside contain the data from the older files and new rows. 

I have all the current files in an appended query. Is it possible to have power Bi updated to grab the new file when the sharepoint folder is updated and to put it into the appended query in an automatic update?

Thanks!

[v-jianboli-msft]

Hi @jgojani ,

Accordinf to my knowledge, your requirement could not be realized by Power BI currently.

Maybe Power Automate could give you some help:

Run flows on a schedule in Power Automate - Power Automate | Microsoft Learn

Use data operations in Power Automate (contains video) - Power Automate | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.