![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 82%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
5,238 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 20%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Hello Aslam
Yes, it is possible to connect to a Microsoft SQL Server database from a Power App, even if the SQL Server is installed on a non-domain PC. Here are the general steps to establish the connection:
Install and configure the on-premises data gateway: Since your SQL Server is installed on a non-domain PC, you will need to set up an on-premises data gateway. The gateway acts as a bridge between your Power App and the SQL Server, allowing secure communication. Follow the instructions provided by Microsoft to install and configure the on-premises data gateway.
Create a connection in Power Apps: Open your Power App in the Power Apps Studio. Navigate to the "Data" tab and click on "New connection". Search for "SQL Server" in the list of available connectors and select it. Provide the necessary details such as server name, database name, authentication method, and credentials to establish the connection.
Configure the connection settings: After creating the connection, you can configure additional settings such as defining tables, views, or queries to retrieve data from the SQL Server database. You can also specify any required filters or transformations.
Use the SQL Server data in your Power App: Once the connection is established and configured, you can start using the SQL Server data in your Power App. You can create screens, forms, galleries, or other components that interact with the SQL Server database. You can perform operations such as reading data, updating records, or executing stored procedures.
It's worth noting that you need to ensure the necessary network and firewall configurations are in place to allow communication between the on-premises data gateway and the SQL Server on the non-domain PC. Additionally, appropriate security measures should be implemented to protect the data and ensure proper authentication and authorization..