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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 335 Most Valuable Professional
11manish 166
sannavajjala87 71 Super User 2026 Season 1
