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
PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

Hi SteveMForm 

With the addition of Greg_Deckler  mentioned
The report does not have the table view, it is using as Direct Query mode
Go to Data Model view, right Properties sidebar > Advance and check the mode

 

Which report is not refreshing, please check the below option in Power Query mode and right click on table
If it is not turn on, please turnon the "Include in Report refresh" option

 


Let me know if that works for you


If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

  • SteveMForm's avatar
    SteveMForm
    Helper III
    2 years ago

    PijushRoy Greg_Deckler 

     

    Ive checked the adbanced properites and its just greyed out import as in your visual.

     

    I looked to go into Power Query mode but didnt proceed as it said it required a direct query connection and was a permanent chnage adding a local model to my file- Im not sure if this is right or will duplicate the semantic models- and if thats ok!

     

    Its all rather hard work !

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      2 years ago

      SteveMForm It's hard to unwind exactly what you have done but you want to end up with this:

       

      • SteveMForm's avatar
        SteveMForm
        Helper III
        2 years ago

        Hi Greg_Deckler v impressive you modelled this out - kudos

         

        So, I can understand the model, but how that is achieved is another matter.

         

        If I look at the workspace in Service, it shows that both reports lineage come from the Front Door Semantic model. When publishing back from desktop, it automatically picks that up as when creating the report in desktop, I used Get Data from Semantic model.

         

        A true representation in your model would be that the service Report 1 semantic model has a direct relationship to the 2 sources as well- it has to surely?

         

        What I am not sure about is how I get report 2 not dependant on semantic model 1 in service, or if thats a red herring?

         

        I think key is how I set report 2 up- as mentioned, I created it in desktop and used get data to get report 2 semantic model- do I need to be doing something different?!

         

        If there are any other details I can provide, just let me know