Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Ramanji
Frequent Visitor

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.

1 REPLY 1
Daryl-Lynch-Bzy
Resident Rockstar
Resident Rockstar

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.