使用 Excel 进行连接Connect with Excel

你创建服务器并向其部署表格模型后,客户端便可以连接并开始浏览数据。Once you've created a server, and deployed a tabular model to it, clients can connect and begin exploring data.

准备阶段Before you begin

用于登录的帐户必须属于具有至少读取权限的模型数据库角色。The account you sign in with must belong to a model database role with at least read permissions. 若要了解详细信息,请参阅身份验证和用户权限To learn more, see Authentication and user permissions.

在 Excel 中连接Connect in Excel

可通过使用 Excel 2016 及更高版本中的“获取数据”在 Excel 中连接到服务器。Connecting to a server in Excel is supported by using Get Data in Excel 2016 and later. 不支持使用 Power Pivot 中的“导入表向导”进行连接。Connecting by using the Import Table Wizard in Power Pivot is not supported.

  1. 在 Excel 的“数据”功能区上,单击“获取外部数据” > “从其他源获取” > “从 Analysis Services 获取”。In Excel, on the Data ribbon, click Get External Data > From Other Sources > From Analysis Services.

  2. 在“数据连接向导”的“服务器名称”中,输入服务器名称,包括协议和 URI。In the Data Connection Wizard, in Server name, enter the server name including protocol and URI. 例如,asazure://chinaeast.asazure.chinacloudapi.cn/advworks。For example, asazure://chinaeast.asazure.chinacloudapi.cn/advworks. 然后,在“登录凭据”中,选择“使用以下用户名和密码”,并键入组织的用户名(例如 nancy@adventureworks.com)和密码。Then, in Logon credentials, select Use the following User Name and Password, and then type the organizational user name, for example nancy@adventureworks.com, and password.

    Important

    如果使用 Microsoft 帐户、Live ID、Yahoo 等登录或被要求使用多重身份验证登录,请将密码字段留空。If you sign in with a Microsoft Account, Live ID, Yahoo, etc., or you are required to sign in with multi-factor authentication, leave the password field blank. 单击“下一步”后,系统会提示输入密码。You are prompted for a password after clicking Next.

    “从 Excel 中连接”登录

  3. 在“选择数据库和表”中,选择数据库和模型或透视,并单击“完成”。In Select Database and Table, select the database and model or perspective, and then click Finish.

    “从 Excel 中连接”选择模型

另请参阅See also

客户端库 Client libraries
管理服务器Manage your server