Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
439 questions
1 answer
One of the answers was accepted by the question author.
Azure Analysis Service - Memory Consumption
All, We are currently hosting Azure Analysis Service (AAS) with S0 pricing tier and this gives us 10GB of RAM. In a On-Prem setup of SQLServer Analysis Service, the engine itself would consume fair amount of RAM and I'm seeing about 1GB of RAM being…
2 answers
Azure Analysis Services - Rolling Back Changes to Data
Is there to a way to roll back changes to an AAS model after it has been processed? I don't see any references to this anywhere.
asked 2020-09-17T15:46:09.997+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 35%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
James H. Robinson
161
Reputation points
commented 2020-09-21T17:53:16.557+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT
46,422
Reputation points Microsoft Employee
1 answer
Azure Analysis Services Partitions and Query Performance
From what I understand, partitions in Azure Analysis Services do not dramatically improve Direct Query performance. Is that correct?
asked 2020-09-14T14:38:16.17+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 80%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
james.h.robinson.csm@gmail.com
6
Reputation points
commented 2020-09-19T10:20:41.767+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
Deleting Specific Rows from a Tabular Table
How can I delete specific rows from an AAS Tabular table? I basically want to do the equivalent of DELETE/FROM/WHERE in SQL.
asked 2020-09-14T18:58:53.927+00:00
james.h.robinson.csm@gmail.com
6
Reputation points
commented 2020-09-19T10:20:13.29+00:00
HarithaMaddi-MSFT
10,136
Reputation points
2 answers
One of the answers was accepted by the question author.
Deleting alreday published Tabular Models from Azure Portal
I have few Tabular Models published on azure resource which I need to delete as clean up process. Please note I DO NOT want to delete resource rather models in those resources. I do not see any delete option when I right click on models in resource,…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 11%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Row Level Security in Tabular Model
Hi, We have a Tabular Model structured to store data from multiple entities in AAS Tabular Model. All tables will carry an Entity Code to identify the Entity Data. We have users belonging to different entities and they can see only the data from their…
asked 2020-09-10T18:50:56.997+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 48%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
Babu Kumar
61
Reputation points
accepted 2020-09-16T15:41:14.063+00:00
Babu Kumar
61
Reputation points
2 answers
Error adding the Sample Model in Analysis Services
I have created an Analysis Services. When I click "New Model", "Sample Data" and click "Add", I get an error: "Failed to create sample model on the Azure Analysis Services server: Either the user does not have…
asked 2020-09-04T08:18:25.267+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 17%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXM%3C/text%3E%3C/svg%3E)
Xavi Marq
1
Reputation point
commented 2020-09-14T08:46:54.643+00:00
PRADEEPCHEEKATLA-MSFT
79,141
Reputation points Microsoft Employee
1 answer
Deploying tabular model to different environments via Dev Ops
Hi guys, I have an issue deploying of xmla model using DevOps to production server. The release pipeline connects to AAS instance and run a query of createOrReplace type. When this step is done on development aas server it works fine but when I try…
asked 2020-09-08T22:49:54.407+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 77%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVN%3C/text%3E%3C/svg%3E)
Vasilyev, Nikolay
6
Reputation points
commented 2020-09-11T09:40:20.993+00:00
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
Azure Runbook fails on schedule but works fine for on demand refreh in Azure Portal
Hello One of my runbooks has been failing for scheduled refresh. When I do an on demand refresh, there is no error. On the recommendation of the Microsoft Support Technician, I had recently upgraded my SqlServer module for some other issue. I fail to…
asked 2020-08-31T18:02:37.067+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 32%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Swati Vishwanathan
1
Reputation point
commented 2020-09-08T17:23:10.027+00:00
KranthiPakala-MSFT
46,422
Reputation points Microsoft Employee
1 answer
Azure Analysis Service Tabular Model Backup
All, In SQLServer, it is easy to check if a backup happened or not by looking at the SQLServer Error Log. How do we find this info on Azure Analysis Service for a backup of a tabular model? We need this info for compliance reason. Thanks, rgn
asked 2020-08-30T13:27:35.683+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 51%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
grajee
346
Reputation points
commented 2020-09-03T12:43:27.827+00:00
PRADEEPCHEEKATLA-MSFT
79,141
Reputation points Microsoft Employee
2 answers
What is the impact of setting ASPaaS\AlwaysUseGateway to false
HI all everybody, this is my first post and I'm here to ask for your help. This is the scenario on my Team: Client - Visual Studio 2019 connecting to AAS deploy using a server of IaaS as data source - issue And they sent me this image…
asked 2020-08-28T02:09:22.31+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 17%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
CuervoXok
1
Reputation point
commented 2020-09-03T04:19:21.907+00:00
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
Azure SSAS gateway connection issue - Received error payload from gateway service
We process the Azure AS tabular model using SSIS on-prem (using a sql agent job). Intermittently (maybe once a week on random days), we receive this error message: The JSON DDL request failed with the following error: Failed to save modifications to…
asked 2020-08-25T16:30:02.687+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 76%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGF%3C/text%3E%3C/svg%3E)
Gabriel Flores
41
Reputation points
commented 2020-08-28T05:32:45.433+00:00
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
Create folders inside the "Tables" folder
Hello community. I have a model with more than 20 tables and I would like to group them by processes within the folder "Tables", being as follows: Tables > Process A >>> Table 1 >>> Table 2 >>> Table 3 …
asked 2020-08-24T22:13:08.213+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 18%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Daniel Castillo
1
Reputation point
commented 2020-08-28T04:09:21.493+00:00
PRADEEPCHEEKATLA-MSFT
79,141
Reputation points Microsoft Employee
0 answers
Azure guest user authentications issues - Excel and PowerBI asking for authentications all the time
Hello, I have an Analysis Service instance running on Azure. Based on this AAS, my users are invited as guest users in my AD tenant. And they are allowed to read the data in AAS through Excel or PowerBI. They have accepted the invitations and created…
asked 2020-08-27T08:22:31.407+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 10%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
ZDUAN
1
Reputation point
commented 2020-08-27T21:15:34.71+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 81%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Marilee Turscak-MSFT
34,626
Reputation points Microsoft Employee
1 answer
Excel connection to azure Analysis service
Hello, I really need your help. I can't connect to Azure Analysis service with Excel. It was working until this morning when I wanted to launch Excel directly from Visual Studio using the "Analyse in Excel" button.
asked 2020-08-19T17:24:51.46+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 74%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Lidou
1
Reputation point
commented 2020-08-25T09:41:18.33+00:00
PRADEEPCHEEKATLA-MSFT
79,141
Reputation points Microsoft Employee
1 answer
Azure Analysis Services/Azure DevOps
Does every new Azure Analysis Services model require a new Azure DevOps repo? Also does every modification to an existing AAS model require a new branch to the ADO repo?
asked 2020-08-18T16:19:01.013+00:00
James H. Robinson
161
Reputation points
commented 2020-08-24T05:13:40.313+00:00
HarithaMaddi-MSFT
10,136
Reputation points
0 answers
Azure Analysis Services model deploys without data
First, I processed the tables in my Azure Analysis Services model using Visual Studio. Data was loaded into each table. But when I deploy that model to the AAS server, no data gets deployed. What am I doing wrong?
asked 2020-08-11T03:32:34.5+00:00
James H. Robinson
161
Reputation points
commented 2020-08-17T10:12:56.647+00:00
PRADEEPCHEEKATLA-MSFT
79,141
Reputation points Microsoft Employee
1 answer
Azure SQL Database queries timing out after 15 minutes.
I have several Logic Apps and SSAS partitions that execute queries which take longer than 15 minutes to run. As of this morning a lot of them have started to timeout at around the 10 - 15 minute mark and I have no idea why. Here's the error message that…
asked 2020-08-03T11:04:29.943+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 32%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Matthew Modget
26
Reputation points
answered 2020-08-13T03:14:27.68+00:00
Mike Ubezzi
2,776
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure Analysis Services tabular model alerts
Hello, We refresh our tabular models on Azure from SSMS through PowerShell scripts. But apparently the jobs don’t fail if the script contains some errors. So sometimes we have cases when all is running OK but our models on AzureAS are not being…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 16%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
3 answers
azure analysis service: how to start and pause service with on premise powershell
Hello All, I need your help. I have an azure analysis service that I want to start and pause at different times of the day. I want to use Powershell to execute a script to do this task. Do you know how I can do it? Thank you for your help
asked 2020-07-29T22:53:27.977+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 57.99999999999999%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHL%3C/text%3E%3C/svg%3E)
H. Laguide
1
Reputation point
commented 2020-08-06T07:04:43.957+00:00
PRADEEPCHEEKATLA-MSFT
79,141
Reputation points Microsoft Employee