Accessing Lakehouse Data in Power Automate

[kwftt]

I would like to use data from my lakehouse inside of a Power Automate Flow and was wondering how i would be able to access that data.

[Anonymous]

Hi @kwftt ,

Is my follow-up just to ask if the problem has been solved?

If so, can you accept the correct answer as a solution or share your solution to help other members find it faster?

Thank you very much for your cooperation!

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Anonymous]

Hi @kwftt ,

Thanks for the reply from frithjof_v .

In addition to the HTTP connector frithjof_v mentioned, I have some other insights.

Power Automate Process Mining gives you the option to store and read event log data directly from Azure Data Lake Storage Gen2. This feature simplifies Extract, Transform, Load (ETL) management by connecting directly to your storage account.

Before using this approach, however, make sure that your Data Lake Storage account is a Gen2 account and that tiered namespaces are enabled.

For more specific configuration information, please refer to this document:

Bring your own Azure Data Lake Storage Gen2 - Power Automate | Microsoft Learn

Here's a case similar to your situation, you can check out what's in it to see if it helps:

Solved: Automate file movement lakehouse > onderive - Microsoft Fabric Community

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[frithjof_v · Accepted solution]

Perhaps a workaround is to call the ADLS API with the HTTP connector in Power Automate:

https://www.reddit.com/r/MicrosoftFabric/s/JUsa1JTlHi

https://www.linkedin.com/pulse/how-call-onelake-api-from-power-automate-enterprise-app-nigel-smith-4...

[frithjof_v]

Please vote for this idea:

Fabric Lakehouse connector

https://ideas.powerautomate.com/d365community/idea/8bb4e21b-ba3f-ef11-b4ae-000d3a05ba58