While dealing with Excel/CSV Files as Source Data for Power BI Report, you may face a common problem inconsistent Names of Files and even some times inconsistent Data structure.
This can be managed much easy without any further Housekeeping in Excel files, to know how Watch this video.
if there are multiple file in that folder, will it work ?