Choosing the Right Data Source for Your Applications

Selecting the right data source is one of the most critical decisions when designing your application infrastructure. Many factors come into play, such as features, security, speed, pricing, and integrations.

Thankfully, your solution’s needs will help you select the right one. For example, it would be better to use a database with a certified connector if you’re going to use Power BI; if your application needs to store a specific data type, it’s best to choose a database that can handle it natively. Another example is working with canvas apps; setting up data sources using different connectors opens a whole range of possibilities when interacting with data.

Before diving into this chapter, we will go into more detail about Power Platform’s licensing model, as this is a crucial topic for Power Platform makers. Having covered the concepts involved in licensing, we will be able to discuss data...