Tutorial: Add a sample model from the portal

In this tutorial, you add a sample Adventure Works tabular model database to your server. The sample model is a completed version of the Adventure Works Internet Sales (1200) sample data model. A sample model is useful for testing model management, connecting with tools and client applications, and querying model data. This tutorial uses the Azure portal and SQL Server Management Studio (SSMS) to:

  • Add a completed sample tabular data model to a server
  • Connect to the model with SSMS

If you don't have an Azure subscription, create a free account before you begin.

Before you begin

To complete this tutorial, you need:

Sign in to the Azure portal

Sign in to the portal.

Add a sample model

  1. In server Overview, click New model.

    Create a sample model

  2. In New model > Choose a datasource, verify Sample data is selected, and then click Add.

    Select sample data

  3. In Overview, verify the adventureworks sample model is added.

    Select sample data

Clean up resources

Your sample model is using cache memory resources. If you are not using your sample model for testing, you should remove it from your server.

These steps describe how to delete a model from a server by using SSMS. You can also delete a model by using the preview Web designer feature.

  1. In SSMS > Object Explorer, click Connect > Analysis Services.

  2. In Connect to Server, paste in the server name, then in Authentication, choose Active Directory - Universal with MFA support, enter your username, and then click Connect.

    Sign in

  3. In Object Explorer, right-click the adventureworks sample database, and then click Delete.

    Delete sample database

Next steps

In this tutorial, you learned how to add a basic, sample model to your server. Now that you have a model database, you can connect to it from SQL Server Management Studio and add user roles. To learn more, continue with the next tutorial.