Showing results for 
Search instead for 
Did you mean: 
Advocate III
Advocate III

Custom connector as data source for a Dataflow?


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?



Community Support
Community Support

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:

Advocate II
Advocate II



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?


2020-09-18 12_10_39-Power Apps.png


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.




Hi @pagonza ,


do you have an idea about the dataflow topic?






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




Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,199)