Connecting to Analysis Services Tabular

This article explains how to connect Dataedo to Azure Analysis Services and SQL Server Analysis, Tabular Model and import metadata - tables & columns.

If you'd like to connect to Power BI Premium dataset/workspace, check this article.

Required privileges

In order to document a tabular model, you need to have the admin role in a tabular database. You can check if you have sufficient privileges by connecting to an Analysis Services server with SQL Server Management Studio. If you cannot see any databases in the list, it means that you do not have permissions to document a model with Dataedo. On the other hand, if you can see the model you want to document in the databases list, Dataedo will document the model. See more SSAS Tabular Roles

Add new connection

To connect to Analysis Services Tabular model, create new documentation by clicking Add and choosing Database connection.

On the add connection screen, choose Analysis Services (SSAS/Azure) Tabular

Connection details

Provide connection details:

• Server name - address of a server or Azure:

  • e.g. 10.10.10.10 for SSAS (server)

  • e.g. asazure://westus.asazure.windows.net/adventure for Azure

• Authentication - choose one of the authentication options:

  • Windows Authentication

  • Azure Active Directory - Password

  • Azure Active Directory - Integrated - this one uses Microsoft online authentication.

• User - for Azure Active Directory - Password authentication.

• Password - for Azure Active Directory - Password authentication.

• Database - if the server hosts multiple models, database allows you to select one of them by clicking the [...] button.

• Perspective - if the model has multiple perspectives, here you can select one of them by clicking the [...] button or leave the default one.

How to get connection details with SSMS

You can get connection details from the Connect to server SSMS form.

How to get server name from Azure

You can get the server name in the Essentials section in Azure Portal.

Saving password

You can save the Azure Active Directory password for later connections by checking the Save password option. Passwords are saved in the repository database.

Importing schema

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

Confirm the list of objects to import by clicking Next.

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

Click Import to start the import.

When done, close the import window with the Finish button.

Outcome

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