Query refresh says 50.000 + rows, but the table has less than 100

[campelliann]

Hi there,

So the refresh is taking too long for no aparent reason (after 2 week holidays). The table ASPnet users in the refresh appears with 50.000 rows, as in the image below. In reality it has less than 100 - at any point of the table transformation the table has more than 100 rows. Any explanation for this?.

Many thanks

[edhans · Accepted solution]

Check with the source table. Something could have happened to cause it. Perhaps you have a filter that is now broken by a change to the source table.

Note too that the record counts here are temporary and may not be final. For example, it may pull 50,000 records but only load 2,000 or 100 after filters or merges are done.

But the fact that it is taking a long time and hasn't before suggests someone has made a change to the source table on the server and your Power Query code wasn't anticipating that.