Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
443 questions
1 answer
On premise data gateway connection issue
I have two global admin account with two different domain, and I want to use a single gateway for the CSV file access. when I log in with the first account then the second account gateway connection is out of the network. Please help me with the…
asked 2020-09-28T08:44:18.863+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, 62%, 22%)' 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)
Serosoft
1
Reputation point
answered 2020-09-29T06:03:27.57+00:00
PRADEEPCHEEKATLA-MSFT
84,531
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
SQLServer 2019, Polybase and Tabular Model
All, From SQL Server 2019, how do I connect to SQL Server Analysis Server (Tabular Model)/Azure Analysis Service using "CREATE EXTERNAL DATA SOURCE". I would like to connect to it using Polybase and extract data from the Tabular data model.…
3 answers
One of the answers was accepted by the question author.
Analysis Services Tabular Model excel in sharepoint
I have created an analysis services tabular model. It has a database connection and a couple of excel files as data sources. When syncing the azure analysis services from the portal, the data does not update. It only updates if I publish from visual…
asked 2020-09-16T11:58:48.063+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(131.20000000000002, 62%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
Palios, Jason
81
Reputation points
commented 2020-09-27T11:21:33.917+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(284.8, 81%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Juli Lis
1
Reputation point
1 answer
Impersonation of Oracle Data Source in Azure Analysis Services
Hi All, We are using Azure Analysis services for building cubes, 1500 level compatibility. I am trying to understanding the impersonation settings while connecting to different data sources... For On-Prem SQL Server - We are using SQL Auth and…
asked 2020-09-08T15:20:24.34+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(275.2, 3%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPY%3C/text%3E%3C/svg%3E)
Praveen Yakkala
1
Reputation point
commented 2020-09-23T23:19:10.15+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(192, 26%, 28%)' 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)
HimanshuSinha-msft
19,376
Reputation points Microsoft Employee
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,437
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
84,531
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,437
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
84,531
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
84,531
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
36,156
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
84,531
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