Changing the DataSource of an Table destroy Meta-Data

[RayWolff]

Hey everyone,

when we create an Table with a Excel Source in Power Bi Dekstop, than create

• DisplayFolder
• IsHidden
• LineageTag
• SortByColumn
• hirarchies
• relationsships 
• 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. 

[v-yingjl]

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:

1. Create and use report templates in Power BI Desktop 
2. Create a Power BI Template file in Power BI Desktop 

Best Regards,
Community Support Team _ Yingjie Li

[RayWolff]

Hi Yingjie Li,

sorry for the late response, we change the datasource in power-query. 

but also when we change the data-source under Transform data the Problem accures. 

for now we create a c# script and restore the Meta-Data with tabular-editor.

best regards

Ramon