Data sources and their different types
Power Apps can connect to hundreds of data sources. Here is a list of popular connectors: Dataverse, SharePoint, Business Central, SQL Server, and Excel. To see the complete list of connectors, visit the Microsoft website: https://learn.microsoft.com/en-us/connectors/connector-reference/.
Data performance is crucial when building apps and other solutions in Power Platform. Using the right data source can help ensure your app or solutions run smoothly and provide a good user experience. First, it is essential to understand that the data source types, Table or Tabular, mean two different things:
- A table is a collection of data stored in rows and columns – for example, in Excel, Dataverse, SharePoint, SQL, and Business Central.
- Tabular is action-based; the data isn’t stored in tables. Instead, it is all driven by different activities. As an example for an Office 365 user, this can be used to add managers to approve timesheets...