Import only 1000 random rows

[AlejandroPCar]

Hi, 

Im importing a table from azure with 40,000 rows. Then I merge with another table and almost the entire table has been merged. But.. once the merge was finish and a new column is added and then I push "close and apply" only 1000 random rows was charged. I tried refresh, I tried doing all again in a new report, different machines, I dont know... In fact the preview in query editor just finish at 1000 rows... it does not let me see anymore. 

This is a problem from July update? That's really weird. 

And when I append a 25,000 rows table with a 252 rows table, only shows in the report 252 rows... does July Update hate append and merge? 

Thanks for your help.

[nayan28apr]

Yes agree, this has happened with me as well when connecting to SQL Server.

As a solution i wrote sql code when importing data in advance editor like below-

This will make below change in M code.

MCode Change:    Source = Sql.Database("ServerName", "DBName", [Query="Select * from TableName"]),

Native Query: https://support.office.com/en-us/article/import-data-from-database-using-native-database-query-power...

Hope this will help

[AlejandroPCar]

Well, in my case the problem just disappeared with desktop august update huy your solution isnt that bad.

[v-chuncz-msft]

@AlejandroPCar,

This seems to be a known issue.

https://community.powerbi.com/t5/Issues/Only-first-1000-rows-loaded-to-model/idi-p/469799