Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Refreshing a report intermittently returns incomplete dataset

Hi all,   I'm having a problem with published reports intermittently ending up with incomplete datasets when the report is refreshed through the Power BI service. It's similar to the issue in this ...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous-- 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's avatar
musicbydannyd
Icon for Advocate IV rankAdvocate IV
8 years ago

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's avatar
    musicbydannyd
    Icon for Advocate IV rankAdvocate IV
    8 years ago

    (reverting back to June 2018 desktop version solves issue)