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

Community site session details

Session Id : bdXvK6LVTUnqpOevDCM4ji
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Custom connector as da...
Power Apps - Microsoft Dataverse
Unanswered

Custom connector as data source for a Dataflow?

Like (1) ShareShare
ReportReport
Posted on 16 Sep 2020 09:33:04 by packnology 138

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

Categories:
Dataflows
I have the same question (0)
  • Pablo Carceller Profile Picture
    Pablo Carceller on 17 Sep 2020 at 09:16:49
    Re: Custom connector as data source for a Dataflow?

    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 Profile Picture
    P3Sven 119 on 18 Sep 2020 at 10:18:51
    Re: Custom connector as data source for a Dataflow?

    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

  • P3Sven Profile Picture
    P3Sven 119 on 28 Sep 2020 at 07:46:33
    Re: Custom connector as data source for a Dataflow?

    Hi @pagonza ,

     

    do you have an idea about the dataflow topic?

     

    BR,

    Sven

  • ElizabethTachji Profile Picture
    ElizabethTachji 2 on 11 Mar 2022 at 04:43:38
    Re: Custom connector as data source for a Dataflow?

    Hi,

     

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

     

    Thanks

    E

  • hjaf Profile Picture
    hjaf 486 on 23 Nov 2022 at 15:17:32
    Re: Custom connector as data source for a Dataflow?

    Sadly the terminology in the docs is ambiguous. Usually "Custom connectors" refers to connectors for Power Automate and Power Apps, while Dataflows (Power Query, that is also available in Dataverse, PowerBI, Excel and Datafactory) uses "Power Query connectors", (which is also referred to as "Custom Connectors for Power Query").

    Custom connectors for Power Query are vastly different from Custom Connectors for power apps/automate, and are not nearly as simple to set up. You can create your own custom connectors for dataflows, but its not as low-code as the rest of power platform.

    https://learn.microsoft.com/en-us/power-query/installingsdk

  • EricChristoph Profile Picture
    EricChristoph 13 on 22 Nov 2023 at 19:40:57
    Re: Custom connector as data source for a Dataflow?

    ...but how do you make that accessible in the Power Apps dataflow after you have created it?

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 714 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 419 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 243

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans