Forum Discussion
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 one that is updating has a table view, the report not updating does not have a table view- is this the issue, and how do I solve it?
Thanks
13 Replies
SteveMForm If this is in the Service, first thing to check is to reset the filters on the report (upper right corner of the report)
Hi Greg_Deckler - this is in Desktop, but it's the same in Service as well and I've checked the filters.
My route for creation was to create a new report > copy visuals from an existing report (now deleted) > connect new report to the shared semantic model as the other working report.
The visuals etc are all good, but the underlying data from SharePoint when changed is not coming through to the new report, but is for the other report.
As mentioned, the other report from the semantic model has a table view, the new report doesn't.
When you hit refresh in Desktop, you get a 'working on it', but it doesnt mention the lists it's getting the updates from, which it does do in the other report
SteveMForm OK, so if the 2nd report is linked to the semantic model of the 1st report and you refresh the 1st report in Desktop, the 2nd report will not reflect the new data until you publish the 1st report to the Service and then refresh the visuals on the 2nd report. The reason you are not getting the updates from the same way in the 2nd report is that the only connection is the semantic model, not the actual source systems. Refreshes do not "pass through" going from a connected semantic model back to the source systems when done from a report that is using the semantic model as a source.
The type of visual is not likely to be an issue.
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 modeWhich 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
LinkedinIve 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 !
