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.