Forum Discussion
Service Reporting Issues
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.
Thank you everyone for the suggestions. I did the steps listed above and have the same result.
The next thing I did was have our system admin send me three sales files, the first has data up to June 16, the next is Jun 17-June 21 (the dates I am having the issues with), and the third is June 22 up to today. I renamed these files to be DailySales1, DailySales2, and DailySales3 and then created a report on the desktop and published each. All three of these reports work correctly.
I then went back and changed the datasource file name, updated the desktop to reference the "new" datasource, and then republished as a new report in the same workspace. Unfortunately I am still not getting any data after June 17.
One other observation from today. I noticed if I remove the filters I have in the desktop related to dates, the data appears to be updating to the correct number if the filters were not relevant. (e.g. if I remove the "IsThisYear = yes" filter, it will give me sales for all years. Is it possible having the date filters with a yes/no criteria are causing this?
Any other ideas?
I followed you up to the last paragraph. What datasource file name did you change? To what new datasource, you had 3 new ones.
On the surface, it appears you recreated a PBIX and it published is working as desired. The old PBIX is leaving data off. Initial speculation is that the old PBIX has a filter that may not be obviuous that is causing the dates to be cut off. either in PowerQuery or front end visuals, page, bookmarks etc.
If you are able to build a PBIX from scratch with the desired datasource and it works / refreshes as expected, then there is something getting filtered in the original build. If you cant find it, you might be better off just using the new build.