Semantic model refresh does not refresh data in report

[x_mark_x]

Hello there Fabricators,

My aim is to create a report that is being refreshed every day by new data automatically.

I created a report in PBI Desktop which has a Lakehouse in my dev_Gold layer as the data source.

I uploaded this report to OneDrive, and I imported this report into my dev_Gold workspace. This created a Report, a Semantic model and a Dashboard in this dev_Gold workspace. 

I deployed the report through deployment pipelines, and in my prod_Gold layer now i have a Report and a Semantic model (as Dashboard is unsupported for Git, it did not get deployed).

In this prod_Gold layer I scheduled a daily refresh for the Semantic model via the Semantic model settings, and configured the gateway that connects to my Lakehouse in the dev_Gold layer.

Every day the Semantic model seems to be refreshed, which is confirmed by the Refreshed column dates next to the Semantic model, and also when I explore the data in the Semantic model.

Then I open my report in the prod_Gold workspace which uses the mentioned Semantic model (which has the refreshed data values) but the Report itself does not show the new data. Refreshing the visuals in the Report does not work.

Only after navigating to the Semantic model in my prod_Gold workspace and refreshing it manually does effect the Report and updates the visuals with the right data.

I had enough of that and thought to create a new report that uses this Semantic model directly as a data source. This report does update with the latest data when opened in PBI Desktop, but when I deploy it in the same way as the initial Report, the same issue arises i.e. the Semantic model has the new data, but not the Report connected directly to this Semantic model.

Here is a visual representation for the workflow that i tried so far:

This issue completely halts my efforts to automate my report refreshes consistently and forces me to refresh the Semantic model manually again after the (succesful) scheduled refresh daily.

Is there anyone who has the same issue, or maybe even a reliable solution?

Also does anyone have a reliable solution for keeping their reports updated, using only the Fabric native tools?

Thank you in advance

[v-echaithra]

Hi @x_mark_x ,

Thank you for your contibution @Shahid12523 , @rohit1991 .

We wanted to follow up to see if the issue you reported has been fully resolved. If you still have any concerns or need additional support, please don’t hesitate to let us know, we’re here to help.
We truly appreciate your patience and look forward to assisting you further if needed.

Warm regards,
Chaithra E.

[x_mark_x]

Hi @v-echaithra ,

As i mentioned to @rohit1991, i am still conducting my tests and will get back with a feedback on monday.

I want to note though that I had the same problem yesterday, as i described in my original post.

I could confirm that i received the new data into the lakehouse, but this time when i checked the data in my semantic model, it was still showing the old data even after a seemingly successfull scheduled refresh, and of course the same applied to the report as well.

After a manual refresh of the semantic model, my report that i connected to it updated the new data and was working fine, but most interestingly the same semantic model did not show the new data when explored.

To add more context, i read up a little about the semantic model refresh, and ended up appending a semantic model refresh activity to my ETL pipeline instead of using the scheduled refresh directly from the semantic model which i even turned off.

After running my ETL pipeline, i immediately checked my report which was showing the new and updated data. As of now, it seems like using the semantic model refresh activity works instead of the scheduled refresh of the semantic model.

To confirm this statement i still need some time for testing, so i might even close this case later next week when i could test the semantic model refresh activity method more thoroughly.

Thank you for your patience!

[Shahid12523]

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.

[x_mark_x]

Thank you for the insight @rohit1991.

I am going to test your solution thoroughly this week, and will get back with my findings latest on monday next week.

[rohit1991]

Hi @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:

1. In Power BI Service, go to Get data <<Power BI datasets.

2. Select your Semantic Model in the Gold workspace.

3. 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: