Create a database connection

This article helps you to create a database connection.

This is a one-time action performed during the initial creation and can be reused later.

Prerequisites

Before you set up Planning sheets, make sure you have the following prerequisites in place:

• Data in a Fabric SQL database

Create a database connection

1. In your Fabric toolbar, select the Settings icon. Select Manage connections and gateways

1. Select New.

2. Select Cloud.

3. Enter a Database Connection name.

4. For Connection type, select SQL database in Fabric.

5. Set the Authentication method to OAuth 2.0.

6. Select Edit credentials, then sign in with your Microsoft account.

7. Select Create to create the connection.

Share the database connection

You can share the created connection and manage the user permissions. Click Manage users.

1. Next to the name of the connection in your Fabric workspace, select ... and Manage users.

1. Edit the permissions and share as needed.

Now that your database connection is created, you can create a Planning sheet that uses this connection: Create a Planning sheet.