Forum Discussion
Semantic model refresh does not refresh data in report
- 11 months ago
I think I may have a solution... I've added a step to hit the endpoint with a simple query before refreshing my model, looks like it might do the trick.
You may want to follow my thread on the subject here: https://community.fabric.microsoft.com/t5/Service/Semantic-Model-connected-to-Lakehouse-SQL-Analytics-endpoint-not/m-p/4828558/highlight/false#M286453
Problem: Dataset (semantic model) refresh works, but reports still show cached/old data.
Cause: Report visuals use query cache, which isn’t always cleared after refresh.
Fixes:
Disable query caching in the semantic model settings.
Use DirectLake auto-refresh if Lakehouse is source.
Trigger a cache clear via API/Power Automate right after dataset refresh.
Build reports with live connection to the semantic model (thin reports).
👉 Best Fabric-native solution: DirectLake + disable query caching.