web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Connection to Power Pl...
Power Automate
Unanswered

Connection to Power Platform Dataflow (Azure Data Lake storage)

(0) ShareShare
ReportReport
Posted on by 182

Hi lovely Community,

 

any idea how to connect to Power Platform Dataflows (analytical) like in Power BI / Power Apps ?

 

Power BIPower BI    Power AppsPower Apps

KSven_0-1609933409706.png

 

Like in my sreenshot, I need the table "districtstatisticmarket" via Power Automate?

Is there a way to connect with Azure Data Lake Action? Like this (I have no own Azure Data Lake Storage Account):

KSven_1-1609933486097.png

 

Hope someone has an idea..

 

BR,

Sven

Categories:
I have the same question (0)
  • murshed Profile Picture
    Microsoft Employee on at

    Hi @KSven 

    I found this document: https://docs.microsoft.com/en-us/power-query/dataflows/overview-dataflows-across-power-platform-dynamics-365

    It says: "For example, Power BI, Power Apps, Power Automate, Power Virtual Agents, and Dynamics 365 applications can get the data produced by the dataflow by connecting to Dataverse, a Power Platform dataflow connector, or directly through the lake, depending on the destination configured at dataflow creation time."

     

    Did you try the Dataverse connector?

  • KSven Profile Picture
    182 on at

    Hi @murshed ,

     

    I've read this document before. Like in screenshot described there are 2 kinds of dataflows:

     

    - Standard V1 -> Dataverse Table as target -> Power Automate Dataverse (Common Data Service (current environment)) Connector works fine

     

    - Analytical -> Azure Data Lake Storage Gen2 -> No Power Automate Connector available (or there's a nice Workaround e.g. per REST API ?)

     

    image.png

     

     

    BR,

    Sven

  • KSven Profile Picture
    182 on at

    Hi @murshed ,

     

    maybe you know whether there will develop a new connector for it?

     

    BR,

    Sven

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard