Azure 上的 SSAS 表格? [英] SSAS Tabular on Azure?

问题描述

我正在尝试部署一个 ssas 表格模型(我不知道我在做什么)

I'm attempting to deploy an ssas tabular model (I don't know what I'm doing )

我已经使用 VS2013 在 SQL Server 2008 R2 上进行了多维操作.我想尝试将 Tabular 与 Power BI 结合使用.

I have made multidimensional on SQL Server 2008 R2 with VS2013. I wanted to try Tabular in conjunction with power BI.

所以我建立了一个 SQL Azure DB，我有 Azure SQL 数据库和 Visual Studio 2013 Pro

So I set up a SQL Azure DB, I have Azure SQL database and Visual Studio 2013 Pro

我可以在 VS2013 中获得到 Azure DB 的连接并针对它编写 T-SQL，但是当我尝试创建表格模型并选择 Azure 数据库作为 SQL Server 工作区时，它无法建立连接.

I can get the connection to the Azure DB in VS2013 and write T-SQL against it but when I try and create a tabular model and select the Azure database as the SQL Server workspace it fails to make a connection.

这与兼容性模块有关还是我需要创建 Azure VM?谢谢你的帮助... p.s.这是我兴奋的第一个问题

Is it something to do with the compatibility module or do I need to create a Azure VM? Thank you for your help ... p.s. this is my fist question ever I'm excited

推荐答案

Azure SQL DB 是一个关系型 SQL 数据库.它不是分析服务.无法将 Analysis Services 数据库部署到 Azure SQL DB.您将需要从 SQL Server Enterprise Edition 映像在 Azure 中创建虚拟机并安装表格实例并打开端口并将表格模型部署到该 VM.

Azure SQL DB is a relational SQL database. It is not Analysis Services. You can't deploy an Analysis Services database to Azure SQL DB. You will need to create a virtual machine in Azure from a SQL Server Enterprise Edition image and install a Tabular instance and open ports and deploy your tabular model to that VM.

2016 年 10 月更新:他们刚刚宣布 Azure 分析服务.虽然它与 Azure SQL 数据库完全分离，但它确实为 Analysis Services 表格模型提供了 PaaS 产品，这意味着您不必为该功能部署 VM.目前支持1200及以上兼容级别的表格模型，不支持多维模型.

Update as of October 2016: They just announced Azure Analysis Services. While it is completely separate from Azure SQL Database, it does provide a PaaS offering for Analysis Services tabular models which means you don't have to deploy a VM for this functionality. Currently it supports 1200 and above compatibility level tabular models, not multidimensional models.

这篇关于Azure 上的 SSAS 表格?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！