Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Changing the DataSource of an Table destroy Meta-Data

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. 

Status: Investigating

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

Comments
v-yingjl
Community Support
Status changed to: Investigating

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
Regular Visitor

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