Create and share a cloud connection for a semantic model

This article explains how to connect to a semantic model from a plan (preview) item.

To connect a plan to a semantic model, a workspace admin or member must create a shareable cloud connection. Other users can use this connection to access the semantic model. The following steps describe how to create and share the connection.

Prerequisites

Before you can create the semantic model connection, make sure you have the following prerequisites in place:

Create a semantic model connection

This connection is used to connect to your semantic models when you create a plan. The following steps must be completed by a workspace admin or member who has access to the semantic model.

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

  1. Select Cloud as the new connection.

  2. Enter a Connection name.

  3. For Connection type, select Power BI Semantic Model.

  4. Set the Authentication method to OAuth2.0.

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

  6. Select Create.

Share the semantic model connection

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

  1. Search the name or email ID of the users to share the semantic model connection.

  2. Set the access permission as User, User with resharing, or Owner.

  3. Select Share to share the connection.

  1. The semantic connection created is shared, which can be accessed by other users.

Other users can now use this shared connection to connect to the semantic model.

Connection types supported in Planning sheet

Planning supports the following connection types:

Connection type
Support status
Requirements

Import mode

Supported fully

Direct Lake

Supported with limitations

Gateway must use fixed credentials (SSO isn't supported at this time)

DirectQuery

Supported with limitations

Gateway must use fixed credentials (SSO isn't supported at this time)

Connect to a Direct Lake semantic model

If you want to connect to a Direct Lake semantic model, follow the steps below. These steps should be performed by workspace Admin or Member users.

  1. Next to the name of the semantic model in your Fabric workspace, select ... > Settings > Gateway & Cloud Connections.

  1. By default, the connection is set to Single Sign On. You can create and use a new connection.

  2. Select Create a connection from the connection list.

  1. Enter the new connection name, and OAuth 2.0 as the authentication method.

  2. Select create.

  1. Select the newly created direct lake semantic model connection from the list and apply.

Next steps

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

Prerequisites for Plan

Trobleshooting guide

Last updated

Was this helpful?