Microsoft Fabric - Data Warehouse

Applies to: Dataedo 24.x (current) versions, Article available also for: 23.x

Catalog and documentation

Data Dictionary

Dataedo imports following report objects from Ms Fabric - Data Warehouse:

  • Tables
  • Views
  • Procedures
  • Functions
  • Dependencies

Descriptions, aliases and custom fields

When technical metadata is imported users will be able to edit descriptions of each object and element, provide meaningful aliases (titles) and document everyting with additional custom fields. Dataedo reads extended properties from following Ms Fabric - Data Warehouse objects:

  • Tables Columns
  • Views Columns
  • Procedures Parameters
  • Functions Parameters

Data Profiling

Users will be able to run data profiling for a table or view in the warehouse and then save selected data in the repository. This data will be available from Desktop and Web.

Connection requirements


Importing database schema requires certain access level in documented database. The user used for importing or updating schema should at least have "View definition" permission granted on all objects that are to be documented. "Select" also works on tables and views.

Finding server name

Open yout Ms Fabric

Image title

On left site panel choose Onelake Data Hub.

Image title

On object list find Warehouse you would like to document and click on three dots [...]

Image title

From conext menu pick Copy SQL connection string.

Image title

Copy it and paste as your Server name.

Image title

Connecting to Ms Fabric - Data Warehouse

Add new connection

To connect to Ms Fabric - Data Warehouse instance create new documentation by clicking Add and choosing Database connection.

Image title

On the connection screen choose MS Fabric.

Image title

and pick MS Fabric - Data Warehouse

Image title

Connection details

Provide connection details:

  • Server name - Name of the server you would like to connect to (if you don't know where to find server name, read explenation above in Connection requirements)
  • Port - Port of the service
  • Authentication - Select the way you want to authorize.
    • Username/password
      • Username - Username to your Ms Fabric - Data Warehouse. eg.
      • Password - Password to your Ms Fabric - Data Warehouse.
  • Connection mode - Select the way you want to encrypt data
  • Database - Name of the Ms Fabric - Data Warehouse database

Image title

Saving password

You can save password for later connections by checking Save password option. Passwords are securely stored in the repository database.

Importing schema

After clicking the Connect button to load workspaces you will need to authenticate and let Dataedo connect to your Ms Fabric Instance.

First, select the account on the Microsoft authentication screen:

Microsoft login

Then, if it's your first use of Dataedo, you need to accept the license agreement and give the required permissions to Dataedo.

Microsoft login2

When the connection was successful Dataedo will read objects and show a list of objects found. You can choose which objects to import. You can also use an advanced filter to narrow down the list of objects.

Confirm list of objects to import by clicking Next.

The next screen allows you to change the default name of the documentation under your schema will be visible in the Dataedo repository.

Click Import to start the import.

When done close import window with Finish button.

Your database schema has been imported to new documentation in the repository.

Importing changes

To sync any changes in the schema in Ms Fabric - Data Warehouse and reimport any technical metadata simply choose Import changes option. You will be asked to connect to Ms Fabric - Data Warehouse again and changes will be synced from the source.

Scheduling imports

You can also schedule metadata updates using command line files. To do it, after creating documentation use Save update command option. Downloaded file can be run in command line, what will reimport changes to your documentation.


Imported metadata

Imported Editable
Tables & External Tables
   Data types
   Identity (is identity on)
   Default value
   Data types
   Identity (is identity on)
   Default value
  Returned value

Supported features

Feature Imported
Import comments
Write comments back
Data profiling
Reference data (import lookups)
Importing from DDL
Generating DDL
FK relationship tester


Dataedo reads comments from following Tableau objects:

Object Read Write back
Tables comments
External tables comments
Views comments

Data Lineage

Source Method Version
Tables (column-level) Metadata API 23.2 (2023)
Views (column-level) Metadata API 23.2 (2023)
Found issue with this article? Comment below
Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.