Anonymous's avatar
Anonymous
Not applicable
4 years ago
Status:
Investigating

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. 

Data Modeling

2 Comments

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    4 years ago
    Status changed:
    New
    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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 

Completed Ideas