# MS Power Automate and Exasol

**URL:** <https://community.exasol.com/t/ms-power-automate-and-exasol/84>\
**Category:** Help Needed\
**Tags:** integration\
**Created:** [May 20, 2025, 1:02pm UTC](https://community.exasol.com/t/ms-power-automate-and-exasol/84 "2025-05-20T13:02:58Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![DomAlbrecht](https://avatars.discourse-cdn.com/v4/letter/d/b9bd4f/32.png) [@DomAlbrecht](https://community.exasol.com/u/DomAlbrecht)\
**Post date:** [May 20, 2025, 1:02pm UTC](https://community.exasol.com/t/ms-power-automate-and-exasol/84/1 "2025-05-20T13:02:58Z")

</div>

Has anyone used something like MS Power Automate to automate the ingestion of data into an Exasol instance ?

---

<div class="post-metadata">

**Author:** ![thomas\_bestfleisch](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@thomas\_bestfleisch](https://community.exasol.com/u/thomas_bestfleisch)\
**Post date:** [May 21, 2025, 3:21pm UTC](https://community.exasol.com/t/ms-power-automate-and-exasol/84/2 "2025-05-21T15:21:19Z")

</div>

@DomAlbrecht we have an Exasol connector which also works with Power Automat [Exasol - Connectors | Microsoft Learn](https://learn.microsoft.com/en-us/connectors/exasol/) . This connector was built for Power Apps to update /insert small number of rows, e.g. some control tables or editing smaller tables. It’s not built for bulk loading, however you can also send freeform SQL for e.g. trigger the [IMPORT Statement](https://github.com/exasol/power-apps-connector/blob/main/doc/user_guide/user_guide.md#advanced-connector-actions).

---

<div class="post-metadata">

**Author:** ![DomAlbrecht](https://avatars.discourse-cdn.com/v4/letter/d/b9bd4f/32.png) [@DomAlbrecht](https://community.exasol.com/u/DomAlbrecht)\
**Post date:** [May 21, 2025, 3:50pm UTC](https://community.exasol.com/t/ms-power-automate-and-exasol/84/3 "2025-05-21T15:50:59Z")

</div>

Thanks for the info @thomas_bestfleisch - I would probably only be looking to process around 10000 rows at a time so I hope that fits into the “small” category! Ill checkout your link

---

<div class="post-metadata">

**Author:** ![thomas\_bestfleisch](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@thomas\_bestfleisch](https://community.exasol.com/u/thomas_bestfleisch)\
**Post date:** [May 21, 2025, 5:56pm UTC](https://community.exasol.com/t/ms-power-automate-and-exasol/84/4 "2025-05-21T17:56:37Z")

</div>

@DomAlbrecht Let us know how your experience are with the connector. Would be great to get feedback.