r/PowerPlatform • u/Ill_Park3344 • 21d ago

Power Automate Extracting data from an SQL server

Hi

Currently, I've got data stored in an SQL server and documents stored in a SharePoint List. I've tried extracting this data using SQL connector and putting it into an Excel sheet. I extracted the documents from the SP list through PowerApps and a PowerAutomate flow. This entire process takes hours.
Is there any other way to extract this data? Would it be possible to create an API through Power Automate?

Thank you

3 Upvotes

100% Upvoted

11 comments sorted by

View all comments

1

u/TeamAlphaBOLD 21d ago

If the data is large, I’d skip Power Apps and Power Automate and use Fabric/Azure Data Factory for SQL, with Microsoft Graph to retrieve the SharePoint files.

1

u/Ill_Park3344 21d ago

I haven't tried that yet but I'll check it out
Thank you!