one model to manage different data source format

Hello,

I am wondering on the best method to use on the following issue :

• I receive different excel fact file from various source, basically most of those file have the same information : date, localization, … stuff like that, but the files have different formats : column name and column title
• I have established to a standard power bi model to analyze those files, with the KPI I want
• I would like to be able to reuse the model to visualize the with the minimum of effort, and by someone with the minimum of technical knowledge

I am wondering what would be the best way to implement that. I have considered the following options :

• Before data loading : have an excel query that would transform my data into some kind of meta model before loading the data
  • I think it might require a bit of technical expertise to do so
• On loading the data : have parameters that would tell the loading scripts which column name to use
  • It might works ok if there is few parameters but it won’t be possible if there is too many of them
• After loading : create a virtual table that would map the meta column name with the raw data
  • Probably the best option

I would hope someone could point me the right direction

 thanks 

g