Forum Discussion
Service Reporting Issues
Not knowing how your online envrionment is configured I will provide guidelines on how I resolve this within our configuration.
If you are using Apps, I almost always see this data mismatch from a local file due to publishing an updated pbix to the workspace and not updating the app.
If you are using a central pbi model saved in workspace A and building a report connected to this model saved in workspace B, the link between the Report and model is broken and the report published to workspace B needs re published.
If you hare using a scheduled refresh ensure your refreshes are succeeding
If you are using an on premise data gateway ensure that the data source is mapped and connnected to the data source
What we have built into our processess to assist in troubleshooting these items is to display a Data As Of on the page iteself. The Data As Of represents when the datasource was updated, often by a max(date) in a fact table. This self created Data As Of date then can be used along side the built in Data Updated avaialable in the service. If the service Data Updated is > self created Data As Of then that tells us that the service successfully refreshed but our data source is stale (often excel sources). If the service Data Updated is < the date we expected to be refreshed, we know something is wrong with the schedule refresh.
Hope something here helps.
Thank you for your suggestions.
To answer some of your questions, I have a gateway on the premises, and the files are shared in a OneDrive folder.
This report is also shared using an app. I did not update the app prior, but I did just try updating it and had the same result. Sales data up to June 17 but nothing after and I still see the one invoice that should be removed. Is there a certain order that I should be updating the app? i.e. should I publish the report and then update the app? And is there something I need to do to update the app other than just clicking the "update app" button in the service?
I am not using a central pbi model for this report.
I have scheduled refresh and it is working without errors. I also have a tile on my report that indicates when the report was updated. This tile is working and reflects the most recent data and time the report was updated. All of my visuals connected to other datasources, which are also saved in the same OneDrive location, are updating properly.
Thank you again for your suggestions. I am totally stuck with this one.
Cheers!