External content by Sébastien Anselment, September, 2025; 

MS Fabric is a powerful platform containing data tables in the Microsoft OneLake. This article describes how to integrate a MS Fabric lakehouse via its SQL analysis endpoint. First you have to set up once the necessary Entra application registration and the WEBCON MSSQL database connection to the lakehouse SQL analysis endpoint. Then you can create as many data sources in WEBCON Designer Studio as you wish to query your tables in the lakehouse.

Microsoft

Entra App

As you need a service principal for your MSSQL connection you have to create a new Entra application registration first if you have none yet for WEBCON's MS Fabric access. You should better use a dedicated app registration instead of using existing WEBCON related app registratios that are used for e.g. user sync, SSO or application proxy. You can find a documentation for this from WEBCON here.

The most relevant screenshots for the necessary data for the configuration of the WEBCON MSSQL connection are:

Client (application) ID

Secret value

MS Fabric Admin Center

Go to the MS Fabric Admin Center and search for "Service principals can call Fabric public APIs" in the "Tenant settings". Enable this option. Only if this option is enabled you can share your lakehouse in the next step with your Entra app. Details can be found here. Select the option under "Appy to" to your needs and click Apply.

MS Fabric

1. Open your lakehouse and note its name.
2. Go to the lakehouse settings and click on SQL analysis endpoint. Now copy the URL string. You will need it later when creating the WEBCON SQL connection.
3. Next click on "Share" and search for your Entra app that you've created before. Enable the checkbox to read all SQL endpoints and disable the checkbox for the mail notification.
4. The tables in your lake house can be queried with SQL in your new WEBCON data source that you'll create in the next chapter.

WEBCON

Set up the SQL connection

Create a new MSSQL database connection and enter the following configuration:

• Authentication: Microsoft Entra Service Principal
• Server: Paste the URL copied from the lakehouse' settings (number 2 above at MS Fabric)
• Database: Enter the name of your shared lakehouse (number 1 above at MS Fabric)
• Client Id: Paste the client id of the Entra app
• Client secret: Paste the secret value (not the ID!) of the Entra app. Don't forget to renew the secret value after it's invalid.

Set up a data source

Now you can create a new MSSQL data source, choose the above created MSSQL connection and you can query all tables of your lakehouse.