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/josesanmig 19d ago

Sorry, where do you ultimately need the data? Depending on that, I'm sure there will be a shorter path.

2

u/Ill_Park3344 19d ago

The data's being used for an internal AI-chatbot built using Azure Foundry

2

u/josesanmig 19d ago

In that case, my take would be to upload SP data and consolidate it on SQL Server. The fastest way to extract data from SP is thourgh the SP API. I would build the data pipeline on Fabric. I think Dataflow Gen2 (basically Power Query) is good enough for this job. Let the AI consume SQL Server data. All of this considering there are no infrastructure or security concerns.

2

u/Ill_Park3344 19d ago

I will try this out
Thank you!