cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

Power BI Desktop: Query Not Fully Loading

I am currently using the latest Power BI Desktop verison (July-2018) and noticed something odd.  I am importing from a table from SQL and then using the power query editor to clean my data.  Once the data is cleaned is shows about 400 records.  I then proceed to Close and Load data and then only 13 records are available in table.  When I refresh and flip back and forth between the query editor and the table in data view the number of records dont match. 

 

I noticed this the other day with another report and after closing desktop and refreshing data a few times it just seemed to fix itself.

 

Anyone else notice this?  I am concerned as my report that end users are using is not showing all records.  Strangely the report has been refreshing daily without issue.

 

Could this be a bug with the July version?

33 REPLIES 33
Highlighted

Yea, the individual tables shows the correct amount of rows, but once you combine them you only get 1000 of each.

 

 

Highlighted

I meant the 1000 rows loaded from each query and displayed in the query editor's preview.

Highlighted

@itayrom, great minds think alike... I too, am "doing it on the database". Still, this issue is obviously not normal. Will post here if support comes up with a resolution.

Highlighted

Understood. Still, I have gotten more that 1,000 rows in editor preview... if I'm patient enough to scroll. Man Frustrated

Highlighted

Still yet to receive response from MS support, but reverting back to June 2018 version of desktop app solves issue (which renders all pbix files edited after July install incompatible). Smiley Frustrated Now it's wait & see if there are any scheduled refresh issues this evening as our enterprise gateway is July version. Ugh.

Highlighted

New version of desktop was posted yesterday, which fixes data load issue, but republishing reports to service still shows incomplete data. Man Mad

Highlighted

Highlighted

Downloaded and installed the latest July 2018 Power BI desktop.  This did resolve my issue on the desktop version.  I will now wait to see what happens over night for when this report is scheduled to be refreshed.

 

Thanks for letting me know about the update.

Highlighted

I have latest version as 2.61.5192.541, released yesterday...

Highlighted

My issue is exactly the same.  I built a simple diagnostic and the table that fails loads exactly 1000 rows when it fails.  I have the new August release of desktop which works fine 100%.  It's when I load to the service that it fails approximately 50-75% of the time.  On prem gateway is July release.

 

Datasource is Postgresql.

 

One other has complained in the issues section of the site here: https://community.powerbi.com/t5/Issues/AWS-hosted-Postgres-Connectivity-Issues/idi-p/483047

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors