Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

how to use tabular editor adding relationship to dataset

Can the tab editor add new tables and relationships when making changes to the cloud dataset? Added a table, but the newly added table is not displayed in the relationship, which is embarrassing

  • Hi, Anonymous 

    According to your description, you want to use the Tabular Editor tool to add a new table to the cloud data source. Right?

    Looking at the relevant information, the Tabular Editor can add new tables to the cloud dataset, which requires the corresponding preconditions, and the corresponding refresh operation is also required after the configuration is completed.

    For specific steps, you can refer to the following document: https://data-goblins.com/power-bi/modify-static-tables-in-tabular-editor

     

    Second, if you want to add a new table to the dataset, you can use Power BI Desktop to connect to the cloud dataset, then convert the Live Connection mode to Direct Query mode, and you can add new tables.

    For connection mode conversion you can refer to the following document: DirectQuery for dataset

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

3 Replies

  • bcdobbs's avatar
    bcdobbs
    Icon for Community Champion rankCommunity Champion

    Yes certainly can. Are you using version 2 or 3?

  • Anonymous's avatar
    Anonymous
    Not applicable

    tabular 2.  using free version only.

  • Hi, Anonymous 

    According to your description, you want to use the Tabular Editor tool to add a new table to the cloud data source. Right?

    Looking at the relevant information, the Tabular Editor can add new tables to the cloud dataset, which requires the corresponding preconditions, and the corresponding refresh operation is also required after the configuration is completed.

    For specific steps, you can refer to the following document: https://data-goblins.com/power-bi/modify-static-tables-in-tabular-editor

     

    Second, if you want to add a new table to the dataset, you can use Power BI Desktop to connect to the cloud dataset, then convert the Live Connection mode to Direct Query mode, and you can add new tables.

    For connection mode conversion you can refer to the following document: DirectQuery for dataset

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly