Forum Discussion
Refreshing a report intermittently returns incomplete dataset
Hi Anonymous,
If you refresh on desktop, did this report up to date? If this is a case, I think power bi service may not update your source data in pbix file so you need to manually refreshed.
In addition, have you turned on incremental refresh feature? It seems like current power bi service contains a known issue on incremental refresh, you can take a look at support page to known more about this.
Regards,
Xaoxin Sheng
Thanks for the response. When I refresh in the desktop application, it always works perfectly. Refreshing through the Power BI service is the only place I run into problems. Strangely, the problem seems to be getting worse. I used to get a proper refresh about half of the time; now it's a lot less.
My report is not using the incremental refresh feature, so that shouldn't be the problem.
Hi Anonymous,
My organization is facing the same problem for a majority of our reports. Using either manual refreshes or scheduled refresh will cause the same problem.
Could you check something for me? Once you have a partial loaded file, download it from the service and open it via Desktop. Go into each query via the Data section and see how many rows are being returned. I notice that some of my queries will be stopped at 1000 or 2000 rows (exact numbers, not a range). Do you experience the same thing?
FYI I have raised this with support and am documenting this problem via the Issues section of the forums as well.
Best,
Cartercarterfritz001-- In the time since making my original post, I gave up and redesigned my report to use a different data source. Unfortunately, I no longer have a copy of the intermittently-broken report.
- musicbydannyd
Advocate IV
Initially I thought I was experiencing the opposite problem, but it turns out both desktop AND PBI service are not working correctly for me. When using desktop app, refresh yields a fraction rows (approx. 16,000 vs. 1,750,000 and usually just a few random dates) from on-premises SQL server... I also have a ticket into support.
FWIW, I am getting some odd behaivior during "Merge Queries" steps. For example, I am merging a small table (71 rows) to the large (1,7500,000 row) table and configuration now says ALL 1,750,000 rows are a match. Anyone else have merges? And if so, look at their column joins?
If it helps, there may be some helpful replies on this thread: https://community.powerbi.com/t5/Desktop/Power-BI-Desktop-Query-Not-Fully-Loading/td-p/479974/highlight/false
Best of luck to all.
