Notifications
Announcements
Dear All,
Can we build the Model Driven app with connecting On-Premise Sql database server ?
If yes please guide me.
Thanks.
Hi @hasanjpm ,
Model-driven apps (as per this post and this reference guide) are DataVerse only, however you can certainly have a Canvas app via on-premises SQL.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
@hasanjpm
One way to connect to an on-premise SQL database from a model driven app is to develop a virtual entity. This is an object that appears like a Dataverse table but connects to an underlying SQL table. This requires some C# expertise and some knowledge on how to secure your database.
https://www.itaintboring.com/dynamics-crm/virtual-entities-revisited-setting-up-a-virtual-entity/
The 'low code' method as @WarrenBelz suggests, is to build a canvas app which you would then embed into your model driven app.
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 721 Most Valuable Professional
Michael E. Gernaey 320 Super User 2025 Season 2
Power Platform 1919 268
