Forum Discussion
Advocate IISemantic model refresh does not refresh data in report
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
Super UserHi x_mark_x
The problem occurs because the report is still connected to the original imported dataset from Desktop, so even though the Semantic Model in the Gold workspace refreshes daily, the visuals do not update. That’s why creating a new report directly on the Semantic Model shows the latest data, while the original report remains stale. The fix is to rebind the report so it points to the Semantic Model in the service:
-
In Power BI Service, go to Get data <<Power BI datasets.
-
Select your Semantic Model in the Gold workspace.
-
Build or republish the report using this Semantic Model.
Once the report is connected this way, it will always reflect the refreshed data from the Semantic Model without requiring manual refresh.
Here’s a simple visual to illustrate: