Forum Discussion
Service Reporting Issues
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!
I am not familiar with OneDrive synchronization but have awareness that the sync could break. See if this explains your issue: https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-excel-file-onedrive#onedrive-or-onedrive-for-business-whats-the-difference
With your set up I would test the following:
1. Local PBIX refresh, did it capture the data as expected?
2. Publish item 1 to the PowerBI Service, does the report in the workspace capture the data as expected? Make a manual edit to the dataset and refresh the power bi report in the workspace. Does the report in the workspace capture the data as expected? If not then there is definitely something going on with your OneDrive sync.
3. Update app. Does the app capture the data as expected?
Using the above you can isolate where the issue is and further research why.