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 t...
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.