one model to manage different data source format

Hi Anonymous，

You can create parameters in your Desktop file to define which excel file(contains specific column name and column title) to connect to, then create reports in  the Power BI Desktop file.

And in order for other users to  use the model in your Power BI Desktop file,  you can create a Power BI Report Template(PBIT file) , the Power BI Report Template contains the definition of the Report (pages, visuals, etc.), Data Model definition (schema, relationships, measures, etc.) and Queries definition (collection of queries, including Query Parameters, etc.). Other users can instantiate your template by double-clicking on the PBIT file, or by using the “File –> Import –> Power BI Template” path.

For more details, please review this blog: https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

Thanks,
Lydia Zhang