Using SQL Server & Power Apps

Use a Azure SQL Server database for your Power Apps application! We'll step through how to do this here!

Here are the topics discussed in this video:
- "Big Boy" database?
- Why SQL Server?
- What's wrong with Dataverse?
- Join tables with view
- Stored procedures (must use Power Automate flows)
- Multiple environments or tenants!
- Data needs to be accessed outside the Power Platform
- You can use Dataverse outside Power Platform
- Why not to use SQL Server?
- Cost
- Dataverse could be faster!
- less API layers!
- you can link other data sources with Dataverse, like SQL Server, SharePoint, Excel, Azure AD, etc.
- Complexity (learning curve)
- Overkill the requirements
- No desire to learn any more coding
- SQL - Structured Query Language
- T-SQL - Transact SQL
- How to set up Azure SQL?
- Creating the database
- Creating our Power Apps application

- Using a sample app use case with Chat GPT:
- Onboarding, Engagement, & Satisfaction!

[PowerAppsTutorial]

🤝 Need to get some help with your project? Join our community here:

[moyura]

@19:08 Dataverse also has View, I think for small dataset size, Dataverse views might offer a better performance. On the other hand, larger and more complex datasets, SQL Server views can provide better performance.

[alexotoous]

Thank you for this video. what is the downside when pushing the final app into production. The biggest problem I have with Dataverse is the cost of licensing every user in production.

[benjaminlahsen]

Hello! Thanks for the tutorial. I have a question regarding the unique identifiers… are you tackling that in this video when you save a record automaticly?
Best regards

[kirankumar-xyxt]

do you have any process for parent data and attachment in child table using sql table in canvas app?

[yaynative]

I loved this video and can't wait to see the rest of the project unfold!

Question: how does one decide whether to store files in a database (like your image column) or just store links to the files?

[johnbrennan]

Hello Darren 1:59 what is the where do we get the username and password to enter there please

[dr.mohammedmohammed]

Dear I used to have an old version of my apps



it was working perfectly so I didn't touch the formula or anything, ,, it expand the gallery perfectly without any errors put so on so far, ,, I think when I update the apps for different modifications not related to this pdf function, the capability is gone, ,,, the last publishing was one year from now, ,, when I update this august the capability gone .... something related to platform update happens by MS them self

[rakeshsen]

Can we integrated sql server without authentication with powerapps?