Online Report

Hi Guys

Any idea to creat Dashboard with automotaic updates , to explain more:

I have excel form ,the perons who fill it will put it specfic  location on share point or whatever  ,How i can make the power BI Apply  the query for one of them and compine all files with each other and at the same time if someone put other files like the same template ,Power BI should update and combine the new one with others ?

Is this possible ? 

Thank You All