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

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.

      • musicbydannyd's avatar
        musicbydannyd
        Advocate IV
        8 years ago

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