Custom connector as data source for a Dataflow?

[packnology]

Hi,

I'm a new Power Apps user and I've been playing around with custom connectors. I've been able to create a connector with multiple GET methods to retrieve data from an on-premise application, and I've set up a connection instance. Now I want to be able to store the data retrieved from those GET methods in a database Entity. Using "Get Data" (Power Query) I can't see how to use my custom connector connection as a data source. Surely that's a fairly logical use for the custom connector? There's a "Web API" source, but I have to configure it again manually, and it only allows me to configure a single GET call for each instance. Am I missing something here?

Thanks,

Greg

[pagonza]

Hello @packnology 

Once you have your custom connector, you can use it inside a flow.

Once you are using the custom connector in a flow, you can select which data source you want to use the save the data, 

Hope this article can help you:

https://docs.microsoft.com/en-us/connectors/custom-connectors/use-custom-connector-flow

[P3Sven]

Hi!

I've the same problem with a Web API I would like to use to import some Big Data into my Common Data Service using "dataflow" together with Power Query as ETL-Tool. So its clear for me how to use my custom REST API connector with Power Automate, but how can I use it with dataflow?

If there's no way to use the custom connector with Dataflow and Power-Query, how could I import "Big Data" with over 10.000 records into CDS without an Power Automate "Apply to each" step? Is there a way to import the json response directly without checking each row (Power Automate CDS connector offers just "Create a new record in entity")...

Hopefully you can understand my issue.

Cheers,

Sven

[P3Sven]

Hi @pagonza ,

do you have an idea about the dataflow topic?

BR,

Sven

[ElizabethTachji]

Hi,

Have you had any luck using a custom connector in a dataflow.

Thanks

E