The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
Solved! Go to 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
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!
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!
Perhaps a workaround is to call the ADLS API with the HTTP connector in Power Automate:
https://www.reddit.com/r/MicrosoftFabric/s/JUsa1JTlHi
Please vote for this idea:
Fabric Lakehouse connector
https://ideas.powerautomate.com/d365community/idea/8bb4e21b-ba3f-ef11-b4ae-000d3a05ba58
User | Count |
---|---|
16 | |
14 | |
8 | |
7 | |
5 |
User | Count |
---|---|
30 | |
24 | |
20 | |
15 | |
10 |