Easy way for Power BI to identify new data sheets automatically

[Anonymous]

Hi all, hope you can help with my problem,

I have a number of data files, all showing the same layout of data but over different time periods eg Week 1, Week 2 etc. The files are all kept in the same folder and as the new week starts, a new file is then added to the folder.

Is there an easy way to set up power BI to auto grab this new file and add it in the same way that the previous sheets have been added in? or do I need to add each sheet in manually? I am trying to set it up to prevent users from having to access the backend of the power BI system, to make it more user firendly.

Thanks,

Charlie

[Pragati11 · Accepted solution]

Hi @Anonymous ,

I think using folder approach in Power BI should help you:

https://powerbi.tips/2016/06/loading-data-from-folder/

You can keep all of your files to a single folder and use this folder as a datasource in Power BI. So, whenever new files come in this folder, Power BI will pull them.

Thanks,

Pragati

[Anonymous]

amazing, perfect solution, thank you