Forum Discussion
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, sinc...
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.