Forum Discussion

SteveMForm's avatar
SteveMForm
Helper III
2 years ago

Report not updating

Hi Folks   I have 2 reports using the same data sources - one is refreshing with updates at source, the other not on manual refresh in Desktop.   One difference I notice between the 2 is that the...
Need Help
SteveMForm's avatar
SteveMForm
Helper III
2 years ago

Hi Greg_Deckler erm- did that, and it's gone a bit loopy and the Horizon report still updating values.

 

Seems like the publishing back has created a new semantic model for the other report- Front Door Report

 

 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

SteveMForm Did you, at some point, rename the report? If you do that, the original report will not be overwritten but instead you will get a new report and a new semantic model in the Service. And, if you connected your 2nd report to the original, original semantic model for the 1st report then, yes, nothing is going to get updated because when you republish, it is going to the 2nd version of your 1st report. Essentially, if you did a rename, you've got 3 reports and 2 semantic models at this point. Not sure if that's the issue but could be.

  • SteveMForm's avatar
    SteveMForm
    Helper III
    2 years ago

    Hi Greg_Deckler - I think you might be onto something- it's almost pythonesque in its convulutedness. 

     

    I did rename the report- and the semantic model at one point (BA Core).

     

    Would it be best to delete the newly created semanitc model and report (front door), create a new report dirctly to the sources and then delete the 2nd report (Horizon, so they both have their own direct link to SharePoint.

     

    Managing workspaces, reports and models seems to be a bit light on MS documentation (ie what not to do, what to do, and the consequences of your actions/ things to avoid/ best practice)?

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      2 years ago

      SteveMForm I'm not sure if you can redirect a report connected to a semantic model to another one. You could leave the current semantic model BA Core as is. Then create a new report that links to the new semantic model and copy and paste your visuals over from your 2nd report that linked to the old semantic model.

      • SteveMForm's avatar
        SteveMForm
        Helper III
        2 years ago

        Hi Greg_Deckler Ive done this, and published the new 2nd report back to workspace.

         

        I checked to see if an update made in SP would pull through to report 2 (Horizon), and it hasn't- square 1. On creation of the new report, it did update the visual to where the last changes should have updated it - ie - its moved on. However, subsequent updates at source are not pulled through.

         

        I was going to publish Front Door (report 1) again to see if that updated things, but it did flag up a warning it was going to replace the dataset:

         

        I also tried a refesh on the semantic model and got a warning:

         

        not sure if it's relevant?