Service Refreshes only partially

Status: New
by carterfritz001 Frequent Visitor on ‎07-25-2018 03:16 PM

TL;DR: Refreshing datasets (on demand and scheduled) in Power BI Service are only partially loading from the source without prompting any errors.

Similar to this post. I have commented there as well.

I have a collection of reports all suffering from the same issue. Here have been my reproduction steps:

  1. Refresh a local copy via Power BI Desktop. -- this will be 100% data complete. 
  2. Publish to web. -- Data matches the local copy still.
  3. Refresh the data set (manually or via Scheduled Refresh). -- Data is now only partially loaded with 0 errors occuring according to Refresh History.

From this point, I download the now-incorrect .pbix and seach for common themes in the partially loaded data. I have noticed that some of the queries will be at exactly 1000 or 2000 rows of data (when the underlying SQL tables are definitely larger than this). Is there possible batching or chunking of data that is erroneously thinking it is complete?

Supplemental Information:

  1. Data source is Azure SQL Server.
  2. Data is not missing from our SQL DB. 
  3. First noticed occurrence on 2018-07-25.
  4. I am on Power BI Pro.
  5. Publishing from Power BI Desktop from the Windows Store. -- I am going to download Power BI Desktop from the website and try this same test.
  6. I am not opted into Incremental Refresh.

Some of my tests and results:

  1. Azure SQL Server is too heavily taxed -- I would expect this to prompt a timeout or similar error.
    • I ramped up our DTUs to the next tier but results are the same.
    • Also, not all reports from the same source are failing.
  2. I tried publishing under a new workspace and a new name (suggestion from my initial support request).
    • Error continued.

Next tests:

  1. Downloading Power BI Desktop from the website and seeing if I achieve different results.
  2. Trying various Data Load settings under Options.
  3. Dive into using SQL Profiler on this.

Any further ideas or suggestions?

by carterfritz001 Frequent Visitor
‎07-25-2018 03:18 PM - edited ‎07-25-2018 06:33 PM

While I was formatting this, I went ahead and downloaded Desktop via the website. Curiously, it fails to load (on desktop this time!) in the same fashion as a refresh within the Service. With this new development, I will definitely foray into SQL Profiler and see what I can learn.


edit: clarified sentence

by Moderator v-yuezhe-msft
on ‎07-26-2018 08:11 PM


This is a known issue and engineers are working on a fix. You can keep an eye on update time in Power BI Support site.


by lucas_ng Visitor
on ‎07-31-2018 07:55 AM

Definitely the same issue I'm facing !!

by JorgenEmborg Frequent Visitor
on ‎08-07-2018 06:42 AM

The issue has now dissapeared from the support site - but I still face the problem?





by carterfritz001 Frequent Visitor
on ‎08-07-2018 07:31 AM

Hi Jørgen,

I'm sorry to hear that. I can confirm that my organization is no longer experiencing this issue. 


by fkristofiak Frequent Visitor
‎08-08-2018 01:09 AM - edited ‎08-08-2018 01:10 AM

You are no longer reporting this on support site but for us, problem remains!!! Append query for two MySQL data sources

by kcantor Super Contributor
‎08-10-2018 09:58 AM - edited ‎08-10-2018 09:58 AM


This is no longer being reported but I am now experiencing this. It is a new issue for me this week. Only affects two of my 100 or so data models. Please advise on how to solve the issue.

Idea Statuses