cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
packnology
Advocate III
Advocate III

Custom connector as data source for a Dataflow?

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

4 REPLIES 4
pagonza
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:

 

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

P3Sven
Advocate II
Advocate II

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?

 

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.

 

Cheers,

Sven

Hi @pagonza ,

 

do you have an idea about the dataflow topic?

 

BR,

Sven

Hi,

 

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

 

Thanks

E

Helpful resources

Announcements
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 (3,068)