when we create an Table with a Excel Source in Power Bi Dekstop, than create
- and all other settings for this Table
After that, we change the source from Excel to an DataBaseSource, alle Columns and Types are the same and there is no issue in power query designer but alle settings are destroyed or missing. The only workaround we actual have, is a c# that running in Tabular Editor. script that gets the Meta-Data from the Service and recreate it in the pbix File.
How did you change the data source in Power BI Desktop, in Transform data -> Change data sources, or change it in Advanced Editor of Power Query
If all the structures are the same, you can consider creating template files in Power BI Desktop, see:
Community Support Team _ Yingjie Li