Forum Discussion

Ramanji's avatar
Ramanji
Frequent Visitor
3 years ago

Excel power query - Value.NativeQuery able update only top 1000 rows to sql table

I have excel table with approx 18K rows, I'm trying to update sql table using Value.NativeQuery function in power query, but it's only updating top 1000 rows, what is the way to update all rows, since my data remarks will keep on changing. 

Note: Earlier I'm able update all rows, recently facing this issue.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Ramanji - it is not recommended to Power Query to update database.  It should only be used to read data.  Would you consider using an VBA based solution to update the SQL Database instead.