cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlejandroPCar
Helper IV
Helper IV

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 3
nayan28apr
Helper I
Helper I

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-

Run native database queries



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

 

Well, in my case the problem just disappeared with desktop august update huy your solution isnt that bad.
v-chuncz-msft
Community Support
Community Support

@AlejandroPCar,

 

This seems to be a known issue.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors