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 : Gc8Wy+jcYMYG0tdHBVcdS+
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Custom Data Provider
Power Apps - Microsoft Dataverse
Unanswered

Custom Data Provider

Like (0) ShareShare
ReportReport
Posted on 25 Jan 2022 19:26:15 by VitalyPopov 36

I need to develop Custom Data Provider that use On-Premises SQL Server Tables as Virtual Tables in Dataverse. Virtual Table Provider does not work. I know, it is possible, when use Azure SQL Database, but if i wont use local SQL instance? Can I use SQL Connection?

Categories:
Microsoft Dataverse
I have the same question (0)
  • a33ik Profile Picture
    a33ik 3,304 Most Valuable Professional on 25 Jan 2022 at 21:33:01
    Re: Custom Data Provider

    Hello @VitalyPopov,

    Technically there should be no difference between Azure SQL and regular SQL one thing you will have to do is to expose your SQL to the external world, i.e. make it available for the external calls. You can start here as a starting point - https://mikefactorial.com/2020/08/15/direct-query-sql-virtual-entities/

  • VitalyPopov Profile Picture
    VitalyPopov 36 on 26 Jan 2022 at 07:16:18
    Re: Custom Data Provider

    Hello, @a33ik 

    Thank you.
    I understand it.     But my question was how to use the local server without publishing it to the outside. I would like to use the approach as a Virtual Provider. Create a connection to a local server using a gateway. It is possible?

  • TaraAssadipour Profile Picture
    TaraAssadipour 79 on 01 Feb 2024 at 17:55:39
    Re: Custom Data Provider

    I have similar problem, what did you eventually do @VitalyPopov ? I wonder if there's a way we can associate a custom virtual table provider with a specific gateway during the registration process in the Power Platform environment.

  • EricRegnier Profile Picture
    EricRegnier 8,716 Most Valuable Professional on 01 Feb 2024 at 18:00:48
    Re: Custom Data Provider

    HI @VitalyPopov, the only way besides exposing your server to the public is with the Power Platform On-Premise Data Gateway. Here's the info and installation: https://learn.microsoft.com/data-integration/gateway/service-gateway-onprem?WT.mc_id=DX-MVP-5004271

    Hope this helps! 

  • TaraAssadipour Profile Picture
    TaraAssadipour 79 on 01 Feb 2024 at 18:13:58
    Re: Custom Data Provider

    Hi @EricRegnier ,

     

    I have an on-pre data gateway already installed. My question is when/how/at what step I should associate it with the custom data provider? is it during the registration?

  • EricRegnier Profile Picture
    EricRegnier 8,716 Most Valuable Professional on 01 Feb 2024 at 18:27:23
    Re: Custom Data Provider

    The association with the data provider is a separate step/process. Once your data gateway is setup successfully and you can connect/use it (test with a simple flow using the Sql Server connector) you can configure your data provider. I recommend using the newish Virtual Data Provider instead of a custom one. More details on Virtual Data Provider: https://learn.microsoft.com/power-apps/maker/data-platform/create-virtual-tables-using-connectors  

  • TaraAssadipour Profile Picture
    TaraAssadipour 79 on 01 Feb 2024 at 18:37:05
    Re: Custom Data Provider

    Thanks for your prompt answer @EricRegnier . The problem with the newish virtual data provider is it does not let me run a join query on the sql side to bring a lookup column into my model driven app. That's why I had to develop a custom virtual table provider (I don't want to use canvas app). I would appreciate it if you can tell me how I can associate my custom data provider with the on-prem data gateway.

  • EricRegnier Profile Picture
    EricRegnier 8,716 Most Valuable Professional on 01 Feb 2024 at 18:58:03
    Re: Custom Data Provider

    I'm not sure if it's possible... Your Sql connection string for the SqlConnection object would need to point to your gateway somehow but can't find any docs that says it's supported... From what I know implementing a custom data provider DLL and registering it to Dataverse is different form allowing custom connectors to the data gateway as explained here: https://learn.microsoft.com/power-bi/connect-data/service-gateway-custom-connectors. But I may be missing something....

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