Show Data from Azure SQL Database in Power Apps Portal App

Display Data from Azure SQL Database in Power Apps Portal

Question

You want to show data from Azure SQL Database in the Power Apps portal app.

What should you do?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

Correct Answer: C

Power Apps portal apps are external websites for interaction with Dataverse data only.

Because portal data is stored in Dataverse, you don't need to use other connectors.

It helps users to focus on the information that they want to present in the portal.

To expose data from Azure SQL Database, you need to import data into Dataverse first and then use it in the portal app.

You can click on the "Get Data" toolbar item in the Power Apps portal to open the data connectors catalog.

Under the Azure tab, you will find Azure SQL Database.

After you provide all required information for the data access, you can import data into your Dataverse environment and use it in the Power Apps portal.

All categories File Database

Data sources

Azure Analysis Services
Azure

Azure SQL database
Azure

Power Platform

Azure Online services Other

Azure Blobs
Azure

Azure Synapse Analytics (SQL ...
Azure

Power Query - Choose data source

w

Azure Data Explorer (Kusto)
Azure

™ Azure Tables

Azure

Azure Data Lake Storage Gen2
Azure

Azure HDInsight Spark
Azure

All other options are incorrect because the Power Apps portal app uses only data from the Dataverse database.

For more information about the Power Apps portal apps, please visit the below URL:

To show data from Azure SQL Database in the Power Apps portal app, you have a few options:

A. Use Azure SQL Database connector to stream data to a portal app This option involves using the Azure SQL Database connector to connect to the database and stream data to the portal app. This option may work well for simple apps with basic data requirements. However, it may not be suitable for more complex apps or situations where you need to handle large amounts of data.

B. Create a canvas app with access to Azure SQL Database data and embed it in a portal app With this option, you would create a canvas app that accesses the Azure SQL Database data and then embed the app in the portal app. This option provides more flexibility and allows you to create a more customized app. However, it may require more development effort and may not be the best option if you need to expose the data to external users.

C. Import Azure SQL Database data to the Dataverse and expose Dataverse data in a portal app This option involves importing the Azure SQL Database data into the Dataverse and then using the Dataverse connector to expose the data in the portal app. This option provides a more robust solution and allows you to take advantage of the Dataverse's data management capabilities. However, it may require more configuration and setup time.

D. Import Azure SQL Database data into SharePoint as a list and expose it in a portal app. This option involves importing the Azure SQL Database data into a SharePoint list and then using the SharePoint connector to expose the data in the portal app. This option may work well if you already have a SharePoint environment set up and want to leverage that infrastructure. However, it may not be the best option if you need to handle large amounts of data or if you want to take advantage of more advanced data management features.

In summary, the best option for showing data from Azure SQL Database in a Power Apps portal app depends on your specific requirements and the complexity of your data. Option B or C are generally the most robust and flexible options, but may require more development effort and configuration time. Option A or D may work well for simpler apps or situations where you already have existing infrastructure in place.