Forum Discussion

tpasley's avatar
tpasley
Frequent Visitor
8 months ago
Solved

Refresh downstream composite model

Hi All, 

We have started using composite models so we can connect to our main data model and still use sorting/aggregate tables without bloating our main model. As part of this though we have found that refreshes on these composite models unless done by downloading and refreshing the .pbix do not update to the latest measures and table definitions from the model it is connected to in directquery. 

I have had a look at doing this programatically using the sempy libraries to find downstream datasets and refresh them but it doesn't appear to resync to the main models definitions.

Any help/guidance would be much appreciated.

Need Help
  • rohit1991's avatar
    rohit1991
    8 months ago

    Hii tpasley 

     

    Downstream composite models cannot automatically pick up new measures or table definition changes from the upstream dataset.
    There is also no workaround or API to force this.

    The only supported method is to open the PBIX, refresh it in Desktop, and republish.

     

2 Replies

  • rohit1991's avatar
    rohit1991
    Super User
    8 months ago

    Hii tpasley 

     

    Downstream composite models cannot automatically pick up new measures or table definition changes from the upstream dataset.
    There is also no workaround or API to force this.

    The only supported method is to open the PBIX, refresh it in Desktop, and republish.

     

  • v-venuppu's avatar
    v-venuppu
    Community Support
    8 months ago

    Hi tpasley ,

    Thank you for reaching out to Microsoft Fabric Community.

    Thank you rohit1991 for the prompt response.

    I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

    Thank you.