Forum Discussion
Import only 1000 random rows
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.
3 Replies
This seems to be a known issue.
https://community.powerbi.com/t5/Issues/Only-first-1000-rows-loaded-to-model/idi-p/469799
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"]),
Hope this will help- Well, in my case the problem just disappeared with desktop august update huy your solution isnt that bad.
