---
title: Fabric Warehouse - Target environment
description: "This article proposes a possible target environment for Fabric Warehouse generators.\nInstallation and configuration of the target environment are not part of biGENIUS support.\nUnfortunately, we won't be able to provide any help beyond this example in this article.\nMany other configurations and installations are possible for a Microsoft Fabric Warehouse target environment."
---

[Skip to content](https://knowledge.bigenius-x.com/fabric-warehouse-target-environment#main-content)

[Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal?hsLang=en)

[![TRI\_Logo\_biGENIUS\_2020\_RGB\_s](https://knowledge.bigenius-x.com/hs-fs/hubfs/Marketing/TRI_Logo_biGENIUS_2020_RGB_s.png?width=150&height=42&name=TRI_Logo_biGENIUS_2020_RGB_s.png)](https://www.bigenius-x.com/)

Open main navigation

Close main navigation

- [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new)
- [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [biGENIUS-X Knowledge Base](https://knowledge.bigenius-x.com/?hsLang=en)
2. [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en)
3. [Target solution environment](https://knowledge.bigenius-x.com/generators?hsLang=en#target-solution-environment)

# Fabric Warehouse - Target environment

This article proposes a **possible target environment for Fabric Warehouse generators**.

Installation and configuration of the target environment are **not part of biGENIUS support**.

**Unfortunately, we won't be able to provide any help** beyond this example in this article.

Many other configurations and installations are possible for a Microsoft Fabric Warehouse target environment.

Below is a possible target environment setup for a **Fabric Warehouse** generator.

### Setup environment

You should have access to a **Fabric Warehouse** target environment:

![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-18-2025-01-55-13-1805-PM.png?width=670&height=362&name=image-png-Mar-18-2025-01-55-13-1805-PM.png)

To activate the git integration later, you should also have access to an Azure DevOps git repository. 

#### Prerequisites

To be able to execute SQL code in a Fabric Warehouse, you must use Azure Key Vault.

More details about how to use Key Vault are available [here](https://learn.microsoft.com/en-us/azure/key-vault/secrets/quick-create-portal).

Create a new Key Vault and the following secrets:

- **client-id**: You can find it in your Azure Enterprise application. It is the application ID:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-10-2026-03-01-51-1404-PM.png?width=670&height=274&name=image-png-Mar-10-2026-03-01-51-1404-PM.png)
- **client-secret**: You can find it during your Azure Enterprise application creation.
- **tenant-id**: you can find it in Fabric by clicking under your profile picture in the top right-hand side, then hovering over the i icon near the Tenant name:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Oct-07-2025-03-32-47-4017-PM.png?width=401&height=205&name=image-png-Oct-07-2025-03-32-47-4017-PM.png)

#### Create a Workspace

Click on the **Workspace** option in the left menu, then on **+ New workspace**:

![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-18-2025-01-57-36-3020-PM.png?width=213&height=340&name=image-png-Mar-18-2025-01-57-36-3020-PM.png)

In this example, we will create a Workspace named *bgDocumentationWarehouse*.

Fill in the name and click on the **Apply** button:

![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-08-58-11-5753-AM.png?width=346&height=404&name=image-png-Mar-09-2026-08-58-11-5753-AM.png)

Service principal (SPN) access to Fabric Data Warehouses requires **tenant-level and workspace-level permissions** that are often not set by default.

To set them, please add to your Workspace a user with the Service Principal level:

- Click on the **Manage Access** button:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-16-2026-09-10-19-5591-AM.png?width=136&height=34&name=image-png-Mar-16-2026-09-10-19-5591-AM.png)
- The Manage access pop-up opens:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-16-2026-09-10-59-5492-AM.png?width=297&height=209&name=image-png-Mar-16-2026-09-10-59-5492-AM.png)
- Click on the **Add people or groups** button:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-16-2026-09-11-34-4621-AM.png?width=233&height=37&name=image-png-Mar-16-2026-09-11-34-4621-AM.png)
- Search the user with the Service Principal level and add it as a Member:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-16-2026-09-12-52-6775-AM.png?width=250&height=195&name=image-png-Mar-16-2026-09-12-52-6775-AM.png)
- You now have it set:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-16-2026-09-14-31-2812-AM.png?width=227&height=206&name=image-png-Mar-16-2026-09-14-31-2812-AM.png)

Now, let's configure the git integration:

- Click on the **Workspace settings** button:
  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-08-58-58-0748-AM.png?width=670&height=52&name=image-png-Mar-09-2026-08-58-58-0748-AM.png)
- Choose the **Git integration** option in the left menu:
  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-08-59-25-4740-AM.png?width=146&height=247&name=image-png-Mar-09-2026-08-59-25-4740-AM.png)
- Connect to your Azure DevOps git repository, then click on the **Connect and sync** button:
  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-09-01-55-9817-AM.png?width=302&height=369&name=image-png-Mar-09-2026-09-01-55-9817-AM.png)

### Source data

There is one way to provide source data to a Microsoft Fabric Warehouse generator:

- From a **One Lake Catalog** by: 
    - using a direct Discovery in a **dedicated Project** using the **Generator Configuration** Microsoft Fabric Warehouse Stage, Data Store, Data Vault, Data Vault and Mart, or Data Mart
    - using the **Fabric Lakehouse Stage** generator as a Linked Project in a **dedicated Project** using the **Generator Configuration** Microsoft Fabric Warehouse Stage

![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-09-10-54-8880-AM.png?width=670&height=299&name=image-png-Mar-09-2026-09-10-54-8880-AM.png)

#### One Lake Catalog

If your source data is stored in a One Lake Catalog, please:

- Direct access: 
    - Create a Project with the *Fabric Warehouse Data Store, Data Vault, Data Vault and Mart, or Data Mart generator*.
    - In this Project, discover the One Lake Catalog, create the Stage Model Object, and use it.

- Access through a linked project: 
    - Create a first Project with the ***Fabric Lakehouse*** ***Stage*** generator
    - In this first Project, discover the One Lake Catalog, create the Stage Model Object, generate, deploy, and load data in a Warehouse.
    - Create a second Project with the *Fabric Warehouse Data Store, Data Vault, Data Vault and Mart, or Data Mart generator*.
    - In this second Project, use the first Project Stage Model Object as a source by using the Linked Project feature.

To **access a One Lake catalog from a Warehouse**, you may create:

- A **Lakehouse shortcut**:
  
    - Click on the **New item** button and choose **Lakehouse**:
      
      ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-09-36-40-0894-AM.png?width=101&height=34&name=image-png-Mar-09-2026-09-36-40-0894-AM.png)\> ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-09-37-36-7837-AM.png?width=217&height=33&name=image-png-Mar-09-2026-09-37-36-7837-AM.png)
    - In this example, we will call the Lakehouse *lakehouse\_shortcut*.

Uncheck the **Lakehouse schemas option**; it is currently not supported.

![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-09-21-53-1810-AM.png?width=427&height=232&name=image-png-Mar-09-2026-09-21-53-1810-AM.png)

- - In the Tables folder, click on the context menu and choose **New shortcut**:![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-09-22-40-4940-AM.png?width=370&height=277&name=image-png-Mar-09-2026-09-22-40-4940-AM.png)
    - Select Microsoft OneLake:
      
      ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-09-23-27-3532-AM.png?width=255&height=234&name=image-png-Mar-09-2026-09-23-27-3532-AM.png)
    - Select the Lakehouse where your source data is located:
      
      ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-09-24-57-8876-AM.png?width=670&height=247&name=image-png-Mar-09-2026-09-24-57-8876-AM.png)

- - Click on the **Next** button.
    - Select your source data:  
      ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-09-26-21-9678-AM.png?width=670&height=331&name=image-png-Mar-09-2026-09-26-21-9678-AM.png)

- - Click on the Next button, then on the Create button.
    - Your source data are now shortcutted in your Workspace:![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-09-27-58-4234-AM.png?width=242&height=349&name=image-png-Mar-09-2026-09-27-58-4234-AM.png)
    - Click on the Next button, then on the Create button.
    - Your source data are now shortcutted in your Workspace:  
      ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-09-34-59-5161-AM.png?width=217&height=313&name=image-png-Mar-09-2026-09-34-59-5161-AM.png)

- A **Warehouse**: 
    - Click on the **New item** button and choose **Lakehouse**:
      
      ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-09-36-50-5287-AM.png?width=107&height=36&name=image-png-Mar-09-2026-09-36-50-5287-AM.png) \> ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-09-37-14-8336-AM.png?width=243&height=34&name=image-png-Mar-09-2026-09-37-14-8336-AM.png)
    - In this example, we call the Warehouse *docu\_bgwarehouse*.

### Upload Artifacts in Microsoft Fabric

There are 2 possibilities to upload the generated artifacts:

- [Using the *deploy.ps1* helper](https://knowledge.bigenius-x.com/fabric-warehouse-target-environment#upload-with-the-deploy.ps1-helper) (recommended)
- [Manually](https://knowledge.bigenius-x.com/fabric-warehouse-target-environment#manual-upload)

Please [replace the placeholders](https://knowledge.bigenius-x.com/generators?hsLang=en#replace-placeholders) before uploading the artifacts.

#### Upload with the deploy.ps1 helper

To use the deploy.ps1 helper to upload the generated artifacts:

- Install the Az.Accounts PowerShell module, which provides cmdlets for managing Azure user accounts, subscriptions, and authentication in Azure Resource Manager: 
    - Open Powershell
    - Execute the following command:

```
Install-Module -Name Az.Accounts
```

- To use the *deploy.ps1* helper, you will need the following information: 
    - **Workspace name**: name of the Fabric workspace where to upload the artifacts
    - **Service principle user name**: your user name in Fabric (email)
    - **Password**: your password
    - **Azure tenant ID**: it is the *tenant-id* value in your Key Vault (check the prerequisites chapter)
    - **Subscription ID**: you can find it by signing into the Azure portal, then navigating to the "Subscriptions" section under Azure services  
      ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Oct-07-2025-03-35-19-9895-PM.png?width=443&height=189&name=image-png-Oct-07-2025-03-35-19-9895-PM.png)

- Open Powershell and execute the deploy.ps1 script: 
    - Enter the workspace name:  
      ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Oct-07-2025-03-36-12-8720-PM.png?width=670&height=95&name=image-png-Oct-07-2025-03-36-12-8720-PM.png)

- - Enter the service principle user name:![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Oct-07-2025-03-39-03-4717-PM.png?width=670&height=128&name=image-png-Oct-07-2025-03-39-03-4717-PM.png)

- - Enter the password:  
      ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Oct-07-2025-03-40-06-7263-PM.png?width=670&height=142&name=image-png-Oct-07-2025-03-40-06-7263-PM.png)
    - Enter the Azure tenant ID:  
      ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Oct-07-2025-03-40-57-2992-PM.png?width=670&height=147&name=image-png-Oct-07-2025-03-40-57-2992-PM.png)
    - Enter the Subscription ID:  
      ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Oct-07-2025-03-46-31-7600-PM.png?width=670&height=253&name=image-png-Oct-07-2025-03-46-31-7600-PM.png)
    - You need to sign in with your Azure credentials:  
      ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Oct-07-2025-03-47-11-7628-PM.png?width=670&height=214&name=image-png-Oct-07-2025-03-47-11-7628-PM.png)
    - All the artifacts are uploaded to your Fabric workspace:  
      ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-10-36-46-0729-AM.png?width=442&height=242&name=image-png-Mar-09-2026-10-36-46-0729-AM.png)

#### Manual upload

To manually upload the generated Artifacts from the biGENIUS-X application to the Fabric Workspace:

- Click on the **Workspace** we just created in the left menu:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-10-37-31-2796-AM.png?width=87&height=86&name=image-png-Mar-09-2026-10-37-31-2796-AM.png)
- Click on the **Import** button and choose **Notebook**, then **From this computer**:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-10-37-58-3381-AM.png?width=670&height=110&name=image-png-Mar-09-2026-10-37-58-3381-AM.png)
- Click on the **Upload** button:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Feb-15-2024-02-40-52-1689-PM.png?width=107&height=48&name=image-png-Feb-15-2024-02-40-52-1689-PM.png)
- Select all the generated artifacts from the folders *Jupyter,* *Helpers,* and *LoadControl*:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-10-37-08-7199-AM.png?width=452&height=247&name=image-png-Mar-09-2026-10-37-08-7199-AM.png)

### Git integration

 Commit all the changes into your git repository by:

- Clicking on the **Source control** menu:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Sep-05-2024-01-31-20-6567-PM.png?width=176&height=42&name=image-png-Sep-05-2024-01-31-20-6567-PM.png)
- Selecting all the changes:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Sep-05-2024-01-31-41-2601-PM.png?width=244&height=368&name=image-png-Sep-05-2024-01-31-41-2601-PM.png)
- Clicking on the **Commit** button:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Feb-15-2024-02-54-37-2558-PM.png?width=99&height=51&name=image-png-Feb-15-2024-02-54-37-2558-PM.png)

If you have already [discovered your source data](https://knowledge.bigenius-x.com/use-the-discovery-application?hsLang=en), [modeled your project](https://knowledge.bigenius-x.com/start-modeling-in-a-branch?hsLang=en), and [generated the artifacts](https://knowledge.bigenius-x.com/generate-artifacts?hsLang=en), you're now ready to [replace the placeholders](https://knowledge.bigenius-x.com/generators?hsLang=en#replace-placeholders) in your generated artifacts, [deploy these artifacts](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment), and subsequently load the data based on the Generator you are using, with the following possible load controls:

- [Load the data with a native load control](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-a-native-load-control)

 

- [Getting started](https://knowledge.bigenius-x.com/getting-started?hsLang=en#main-content)

    - [Guidelines](https://knowledge.bigenius-x.com/getting-started?hsLang=en#guidelines)
    - [Start working](https://knowledge.bigenius-x.com/getting-started?hsLang=en#start-working)
    - [Account](https://knowledge.bigenius-x.com/getting-started?hsLang=en#account)
- [General overview](https://knowledge.bigenius-x.com/general-overview?hsLang=en)
- [Artificial Intelligence](https://knowledge.bigenius-x.com/artificial-intelligence?hsLang=en)
- [Application Modules](https://knowledge.bigenius-x.com/application-modules?hsLang=en#main-content)

    - [Administration](https://knowledge.bigenius-x.com/application-modules?hsLang=en#administration)
    - [Solutions](https://knowledge.bigenius-x.com/application-modules?hsLang=en#solutions)
    - [Global Features](https://knowledge.bigenius-x.com/application-modules?hsLang=en#global-features)
    - [Projects](https://knowledge.bigenius-x.com/application-modules?hsLang=en#projects)
    - [Branches](https://knowledge.bigenius-x.com/application-modules?hsLang=en#branches)
    - [Data Connections](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-connections)
    - [Dataflow Modeling - Overview](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-overview)
    - [Dataflow Modeling - Wizard Steps](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-wizard-steps)
    - [Dataflow Modeling - Terms](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-terms)
    - [Dataflow Modeling - Term Mapping](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-term-mapping)
    - [Dataflow Modeling - Relationships](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-relationships)
    - [Dataflow Modeling - Data Quality](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-data-quality)
    - [Dataflow Modeling - Indexes](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-indexes)
    - [Relationship Modeling](https://knowledge.bigenius-x.com/application-modules?hsLang=en#relationship-modeling)
    - [Generate Artifacts](https://knowledge.bigenius-x.com/application-modules?hsLang=en#generate-artifacts)
    - [Project Settings](https://knowledge.bigenius-x.com/application-modules?hsLang=en#project-settings)
    - [Data Marketplace](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-marketplace)
- [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en#main-content)

    - [Fabric Warehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-warehouse)
    - [Fabric Lakehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-lakehouse)
    - [Databricks](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks)
    - [Snowflake](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake)
    - [Microsoft SQL Server](https://knowledge.bigenius-x.com/generators?hsLang=en#microsoft-sql-server)
    - [Artifacts](https://knowledge.bigenius-x.com/generators?hsLang=en#artifacts)
    - [Replace Placeholders](https://knowledge.bigenius-x.com/generators?hsLang=en#replace-placeholders)
    - [Target solution environment](https://knowledge.bigenius-x.com/generators?hsLang=en#target-solution-environment)
    - [Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment)
    - [Deployment with an Azuze DevOps pipeline](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment-with-an-azuze-devops-pipeline)
    - [Delta Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#delta-deployment)
    - [Load control environment](https://knowledge.bigenius-x.com/generators?hsLang=en#load-control-environment)
    - [Load data with a native load control](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-a-native-load-control)
    - [Load data with Apache Airflow](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-apache-airflow)
    - [Model Object Type](https://knowledge.bigenius-x.com/generators?hsLang=en#model-object-type)
    - [Properties](https://knowledge.bigenius-x.com/generators?hsLang=en#properties)
    - [Default Terms](https://knowledge.bigenius-x.com/generators?hsLang=en#default-terms)
- [Discovery application](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#main-content)

    - [Discovery configurations](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#discovery-configurations)
- [Best practices](https://knowledge.bigenius-x.com/best-practices?hsLang=en#main-content)

    - [Modeling Approaches](https://knowledge.bigenius-x.com/best-practices?hsLang=en#modeling-approaches)
    - [Use Cases](https://knowledge.bigenius-x.com/best-practices?hsLang=en#use-cases)
    - [Business Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#business-rules)
    - [Data Quality Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#data-quality-rules)
- [FAQs](https://knowledge.bigenius-x.com/faqs?hsLang=en)
- [Product Release Notes](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#main-content)

    - [SaaS Application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#saas-application)
    - [Discovery application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#discovery-application)
    - [Generators](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#generators)
- [Legal Documents](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#main-content)

    - [Current legal docs](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#current-legal-docs)
    - [Software Product and Limits](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#software-product-and-limits)

- [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en)
- [Customer Portal](https://knowledge.bigenius-x.com/customer-portal)
- [Sign in](https://knowledge.bigenius-x.com/_hcms/mem/login)

[![biGENIUS logo](https://knowledge.bigenius-x.com/hubfs/TRI_Logo_biGENIUS_2020_RGB-1.svg "biGENIUS logo")](https://www.bigenius-x.com)

<https://www.linkedin.com/company/bigenius> <https://www.youtube.com/@biGENIUS_DWA>

All rights reserved © 2025, biGENIUS AG