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.

itayrom's avatar
itayrom
Resolver II
8 years ago

It seemed to me that those 1000 rows we get from each query where this issue occurs is its preview data.

musicbydannyd's avatar
musicbydannyd
Advocate IV
8 years ago

Nope... if you look at bottom of "Data" section (not "Report" or "Relationships") in PBI Desktop, you'll see how many rows have been loaded for each query. I've have some with millions, but the "bad" table loads exactly 1,000.

  • itayrom's avatar
    itayrom
    Resolver II
    8 years ago

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

    • musicbydannyd's avatar
      musicbydannyd
      Advocate IV
      8 years ago

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

      • musicbydannyd's avatar
        musicbydannyd
        Advocate IV
        8 years ago

        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). :smileyfrustrated: Now it's wait & see if there are any scheduled refresh issues this evening as our enterprise gateway is July version. Ugh.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

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