教程:从门户添加示例模型Tutorial: Add a sample model from the portal

在本教程中,将向服务器添加示例 Adventure Works 表格模型数据库。In this tutorial, you add a sample Adventure Works tabular model database to your server. 此示例模型是 Adventure Works Internet Sales (1200) 示例数据模型的完整版本。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. 本教程使用 Azure 门户SQL Server Management Studio (SSMS) 执行以下操作:This tutorial uses the Azure portal and SQL Server Management Studio (SSMS) to:

  • 将已完成的示例表格数据模型添加到服务器Add a completed sample tabular data model to a server
  • 使用 SSMS 连接到模型Connect to the model with SSMS

如果没有 Azure 订阅,请在开始前创建一个试用帐户If you don't have an Azure subscription, create a trial account before you begin.

先决条件Prerequisites

要完成本教程,需要:To complete this tutorial, you need:

登录到 Azure 门户Sign in to the Azure portal

登录门户Sign in to the portal.

添加示例模型Add a sample model

  1. 在服务器“概述”中,单击“新建模型”。In server Overview, click New model.

    创建示例模型

  2. 在“新建模型” > “选择数据源”中,确认已选中“示例数据”,然后单击“添加”。 In New model > Choose a data source, verify Sample data is selected, and then click Add.

    选择“新建模型”

  3. 在“概述”中,确认是否添加了 adventureworks 示例模型。In Overview, verify the adventureworks sample model is added.

    选择“示例数据”

清理资源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.

下面的步骤介绍了如何使用 SSMS 从服务器中删除模型。These steps describe how to delete a model from a server by using SSMS.

  1. 在 SSMS >“对象资源管理器”中,单击“连接” > “Analysis Services”。In SSMS > Object Explorer, click Connect > Analysis Services.

  2. 在“连接到服务器”中,粘贴服务器名称,然后在“身份验证”中选择“Active Directory - 支持 MFA 的通用身份验证”,输入你的用户名,然后单击“连接”。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.

    登录

  3. 在“对象资源管理器”中,右键单击 adventureworks 示例数据库,然后单击“删除”。 In Object Explorer, right-click the adventureworks sample database, and then click Delete.

    删除示例数据库

后续步骤Next steps

本教程介绍了如何将基本示例模型添加到服务器。In this tutorial, you learned how to add a basic, sample model to your server. 现在,已有模型数据库,可以从 SQL Server Management Studio 连接到它,并添加用户角色。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.