Edit

Specify a fixed identity for a Direct Lake semantic model

  • Article

Follow these steps to specify a fixed identity connection for a Direct Lake semantic model.

  1. In your Direct Lake model's settings, expand Gateway and cloud connections. Note that your Direct Lake model has a SQL Server data source pointing to a lakehouse or data warehouse in Fabric.

    Screenshot of Direct Lake model settings.

  2. In the Maps to listbox, select Create a connection. A New connection pane appears with some data source information already entered for you. Specify a connection name.

  3. In Authentication method, select OAuth 2.0 or Service Principal, and then specify credentials for the fixed identity you want to use.

    Screenshot of authentication credentials specified in new connection settings.

  4. In Single sign-on, ensure SSO via Microsoft Entra ID for DirectQuery queries is not selected.

    Screenshot of Single sign-on where option is not selected.

  5. Configure any additional parameters if needed and then click Create.

  6. In the Direct Lake model settings, verify the data source is now associated with the non-SSO cloud connection.

Related content