How to export ALL row from azure SQL DB

(0) Share

Report

Posted on by thanakidtk

Hi Guy,

Please advise , I have use the "get rows" function to export the data from Azure SQL DB but number of total export record look like not mapping with original Azure SQL DB,

Screenshot 2020-09-16 150608.png Screenshot 2020-09-16 150641.png

Screenshot 2020-09-16 150708.png

All responses (1)

Answers (0)

rsaikrishna

3,703 on at

Like (0)

Report

Re: How to export ALL row from azure SQL DB

@thanakidtk

Power Automate is very attractive to automate but, we definitely need to keep many things in mind such as Throttling limits, API calls per day, Premium Connections.

So, SQL in built supports functionality to export the data from a table or view as .csv file. You can also schedule a SQL job and run the SQL jobs on schedule. I recommend using it rather than automating with Power Automate.

If you still want to use Power Automate for this use case, can you please provide a use case?

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.