Connection to Power Platform Dataflow (Azure Data Lake storage)

[KSven]

Hi lovely Community,

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

Power BI    Power Apps

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):

Hope someone has an idea..

BR,

Sven

[murshed]

Hi @KSven 

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

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]

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 ?)

BR,

Sven

[KSven]

Hi @murshed ,

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

BR,

Sven