Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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
This seems to be a known issue.
https://community.powerbi.com/t5/Issues/Only-first-1000-rows-loaded-to-model/idi-p/469799
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |