Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
IamTDR
Responsive Resident
Responsive Resident

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?

1 ACCEPTED SOLUTION

All, after installing August desktop app AND August on-premises gateway, no more issues for me.

View solution in original post

33 REPLIES 33

Just thought to check O365 admin portal and found this... seems it's been an issue for several weeks:

 

Status:
Service degradation
User impact:
Users may see missing or incomplete data when refreshing reports, viewing reports or dashboards.
Latest message:
Title: Incomplete or missing data User Impact: Users may see missing or incomplete data when refreshing reports, viewing reports or dashboards. More info: Customers utilizing specific connectors when refreshing datasets without using native SQL queries, pulling SQL data that does not include a SQL primary key column in the final result, and doing Append or Merge operations may experience this issue. The following is a list of connectors impacted: SQL Server, Oracle, PostgreSQL, MySQL, Teradata, Sybase, Informix, DB2 or Access. Current status: We've initiated the deployment of the fix to the affected environment. We anticipate the deployment process completing by the end of this week. Scope of impact: Impact is specific to a subset of users who are served through the affected infrastructure. Start time: Friday, July 13, 2018, at 10:08 PM UTC Preliminary root cause: A recent update to the Power BI services resulted in missing or incomplete data when refreshing reports, viewing reports or dashboards in some scenarios. Next update by: Friday, August 3, 2018, at 7:00 PM UTC

Any thoughts on a work-around for this issue.  Like I mentioned in my post above, from Query Editor I should have around 400 transactions, but after Close & Applied I am left with only 13-14 transactions. Very strange.  Not sure how to proceed at this point either.

I tried publishing a copy of my desktop file, thinking if I refreshed dataset from PBI service, all would be well, but no luck. Smiley Sad You could try "downgrading" to an earlier desktop version. Otherwise, we may have to wait for MS to fix.

I rather not downgrade to an earlier version of Power BI right now.  I'm gonna wait for my overnight process to complete to see if it resolves itself

If something changes on my end, I'll post here... good luck!

Anonymous
Not applicable

Is there a fix to this yet?

 

I don't see the notification on https://powerbi.microsoft.com/en-us/support/ anymore.

 

 

This is really screwing with almost all of our reports.

 

 

I saw the notification removal as well and was still experiencing the issue, so I submitted support ticket... spent about an hour this morning with an engineer, who was not able to resolve the issue. Sent an example pbix along with some log files and am waiting to hear back. Once again, I'll let you know if I hear of anything.

Will be interested in the response as well.

MS support has isolated a "NaN" error in a line chart from a measure which uses a "SUMX" formula... do you see anything like this on your end?

Nope.  No SUMX at all.

Any "Merge Queries" steps?

Yes.  I did use a merge query.  However, I use them alot and my other reports have yet to have an issue

Also, something funky going on with a merge step in my query... table 1 has 1,755,000+ rows and table 2 has 71 rows, yet merge showing table 2 matches ALL rows in table 1.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.