在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数据库，我有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数据库的连接，并针对该数据库编写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?谢谢您的帮助.这是我很兴奋的拳头问题

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.您不能将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月更新:他们刚刚宣布

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屋！