Answered

Connecting Custom Virtual Table Provider to Power Platform On-Premises Data Gateway

(0) Share

Report

Posted on by TaraAssadipour

Hello everyone,

I'm working on a model-driven application that requires a connection to an on-premises SQL Server. My SQL Server database includes two tables, where one serves as a lookup for the other. Due to the need for a join query and the limitations of the existing SQL connector, I've developed a custom virtual table provider.

Now, I'm trying to figure out how to associate this custom provider with the Power Platform on-premises data gateway. Since the SQL Server is not publicly exposed, I believe I need to leverage the Power Platform on-premises data gateway.

Any guidance on how to link my custom virtual table provider with the Power Platform on-premises data gateway would be greatly appreciated.

Thank you!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

julianaveiga 6 on at

Like (0)

Report
Copy link

Link copied!

Hi, TaraAssadipour

Did you try to use view in you SQL Server Query?

I think this link can help you
https://powerapps.microsoft.com/pt-br/blog/using-sql-server-views-in-powerapps/

There are some limitations like cannot update or delete records in you SQL server database. But you will need a gateway

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Linking it to similar thread for conveniency: https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Custom-Data-Provider/m-p/2582899#M37551

Was this reply helpful? Yes No
TaraAssadipour 79 on at

Like (2)

Report
Copy link

Link copied!

I had a dream, a SQL dream! I dreamt of a world where tables join hands, embrace each other's columns, and dance in perfect harmony. Alas, my SQL servers, shy and hidden from the public eye, decided to keep their columns to themselves. So here I am, stuck in a world where tables prefer solitude over a joined party. Oh, what a whimsical SQL dream it was!

Was this reply helpful? Yes No
Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hehe your dream is mostly likely share out there 😉 I would suggest to submit a Microsoft support ticket in hopes to get some support/guidance on this. It is indeed IMO lacking in documentation.
Also, I would submit the idea at: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

Was this reply helpful? Yes No
TaraAssadipour 79 on at

Like (1)

Report
Copy link

Link copied!

@EricRegnier would you vote for my idea:
Seamless Integration with On-Premises SQL Servers and Custom Virtual Table Providers · Community (powerapps.com)

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Done!

Was this reply helpful? Yes No