Geek Answers Handbook

SSAS Tabular on Azure?

I'm trying to deploy a ssas tabular model (I don't know what I'm doing)

I did multidimensional on SQL Server 2008 R2 with VS2013. I wanted to try Tabular in combination with Power BI.

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

I can get a connection to Azure DB in VS2013 and write T-SQL against it, but when I try to create a table model and select the Azure database as the SQL Server workspace, it will not be able to establish a connection.

Is this something related to the compatibility module or do I need to create an Azure VM? Thank you for your help ... ps this is my first question, am i ever excited

+7
sql azure sql-server-2008-r2 azure-sql-database ssas
source share
2 answers

Azure SQL DB is a relational SQL database. These are not analytical services. You cannot deploy an Analysis Services database for Azure SQL DB. You will need to create a virtual machine in Azure using the SQL Server Enterprise Edition image and install a Tabular instance and open ports and deploy your tabular model for this virtual machine.

October 2016 Update : They just announced Azure Analysis Services . Although completely separate from the Azure SQL database, it provides a PaaS offer for Analysis Services table models, which means you don’t need to deploy a virtual machine for this feature. It currently supports 1200 and higher tabular models of compatibility level, rather than multidimensional models.

+7
source share

Analysis Services is now available as a service that can be provided directly in the Azure Portal (no VM required):

https://azure.microsoft.com/en-gb/documentation/articles/analysis-services-overview/

+2
source share

More articles:


All Articles