Forum Discussion

rbowen's avatar
rbowen
Icon for Helper III rankHelper III
1 year ago
Solved

Shared Semantic Model Refreshes But Report It's Feeding Does Not

I'm in the process of converting our BI reports to a shared semantic model and running across an issue I can't quite figure out. I built a semantic model in BI Desktop with everything I need for a collection of reports I'll be using it for. The semantic model lives in its own workspace called Semantic Models. I've set the SM to refresh the data daily, Monday thru Friday. This appears to be working as it should with the refresh timestamp showing the daily refreshes are happening. 

 

I then created a report, also in BI Desktop, using that semantic model as the data source. The report is created successfully and published to a different workspace called Retail. My assumption is that, as the SM refreshes each day, the report it is feeding should also show the updated data but it isn't. The lineage view in the BI service shows what appears to be the correct relationship between the report and the SM. 

 

In the Admin Portal, I have the Enable semantic models across workspaces option enabled and set to The entire organization.  The report itself is not configured to use a gateway, but the semantic model is and it's working fine. Is there something I'm missing to get the report to update along with the shared semantic model it's using?

  • Hi rbowen 

     

    What you are experiencing is by design. What I mean by this is that the power BI reports always caches the last known state of a report. As you interact with the report, it would then show you the updated data. Another way to do this is you click on the refresh visuals button in the power BI service, which will then get the latest information from the semantic model.

2 Replies

  • Hi rbowen 

     

    What you are experiencing is by design. What I mean by this is that the power BI reports always caches the last known state of a report. As you interact with the report, it would then show you the updated data. Another way to do this is you click on the refresh visuals button in the power BI service, which will then get the latest information from the semantic model.

  • v-sgandrathi's avatar
    v-sgandrathi
    Icon for Community Support rankCommunity Support

    Hi rbowen,


    Thank you GilbertQ for addressing the issue. As mentioned When interacting with the report, it may retrieve the latest data if using a Live Connection or DirectQuery. Alternatively, you can manually refresh the report by clicking the Refresh visuals button in the Power BI service, which will fetch the most recent data from the semantic model. 

    If the report uses Import Mode, a scheduled or manual dataset refresh is required to update the data.

    Please Accept as solution if this meets your needs and a Kudos would be appreciated.

    Regards,
    Sahasra.