Forum Discussion
Refreshing a report intermittently returns incomplete dataset
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,
Carter
carterfritz001-- 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.
- musicbydannyd
(reverting back to June 2018 desktop version solves issue)
