Forum Discussion

IamTDR's avatar
IamTDR
Responsive Resident
8 years ago
Solved

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...
General Comment
  • musicbydannyd's avatar
    musicbydannyd
    8 years ago

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

musicbydannyd's avatar
musicbydannyd
Advocate IV
8 years ago

I am experiencing this as well... I also have a query to load from SQL server and when refreshing from Desktop, only a few rows (from January 2016) are loaded. Went to query editor to troubleshoot, refreshed preview, and things seemed to go awry during a split column step. Refreshing preview while selecting this step loads random other dates. Weird.

  • musicbydannyd's avatar
    musicbydannyd
    Advocate IV
    8 years ago

    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
    • IamTDR's avatar
      IamTDR
      Responsive Resident
      8 years ago

      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.

      • musicbydannyd's avatar
        musicbydannyd
        Advocate IV
        8 years ago

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