You’re offline. This is a read only version of the page.
79
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!
Done!
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
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!
Linking it to similar thread for conveniency: https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Custom-Data-Provider/m-p/2582899#M37551
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
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
