Forum Discussion
Composite model Refresh issue
This is expected behavior with composite models. Refreshing the consolidated semantic model does not automatically refresh the three original semantic models.
I would suggest checking these things:
- Check the refresh history of all three source semantic models. Make sure their scheduled refreshes are completing successfully.
- Check whether query caching is enabled on the consolidated semantic model. Disable it temporarily and test again.
- Check for calculated tables based on remote tables, as these may need their own refresh.
- After refreshing, republish the report and verify that the Power BI App is showing the latest version.
Important: If the three reports use different semantic models, you need to manage their refresh schedules independently. The 1-second refresh of your consolidated model does not mean the source data has been refreshed.
Resolver IHi, this is expected with composite models.
When you add another source to a live connection, the tables from the published model become DirectQuery to that model. Your report's refresh only reloads the extra imported table, that's why it finishes in a second.
So the old data is coming from the source semantic model. A few things to check:
- Is the source model's scheduled refresh running and succeeding?
- Are credentials set for the extra source in the new model?
- Any calculated tables based on the remote tables? Those only update on your refresh.
Also, if the extra data can be added to the source model, you could skip the composite model and build one report on a live connection with a taller page.