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.

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.