Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
444 questions
1 answer
One of the answers was accepted by the question author.
Options/Query hints in DAX
Are there any options or query hints available in DAX to query a specific partition in an Azure analysis services tabular model table partition. This answer to this question helps us to consider whether including any specific column for partitioning will…
asked 2021-04-28T13:57:49.97+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(166.4, 60%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Raja Mallela
21
Reputation points
accepted 2021-05-04T03:25:58.627+00:00
Raja Mallela
21
Reputation points
1 answer
How to execute a DMV query in SSAS through a powershell runbook from Azure Automation?
I am trying to open a connection with a ssas server and execute a dmv query in order to extract table metadata, through a powershell runbook from an Azure Automation Account. I have already written and tested a powershell script that seems to work fine…
asked 2021-04-28T15:33:27.21+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(313.6, 82%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFB%3C/text%3E%3C/svg%3E)
Fabio Beka
1
Reputation point
commented 2021-04-29T08:23:06.527+00:00
Fabio Beka
1
Reputation point
1 answer
One of the answers was accepted by the question author.
In Tabular Cube, can repoint an existing table to use a different data source connection type
Hi, Is it possible to repoint existing tables to a new data source type, without recreating them from scratch? My Analysis services cube was upgraded from compatibility version 1200 to version 1400, which has a newer connection type called…
asked 2021-04-20T14:50:48.077+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(278.4, 34%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Abhay Sudhakaran
101
Reputation points
commented 2021-04-27T02:29:31.677+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,381
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Is AAS receiving ongoing investment, or is it being deprecated?
Does anyone know if there are plans to continue developing AAS (PaaS in azure)? There are clues that indicate that it is being abandoned, just as multidimensional was. The blog hasn't been touched in ages, the consultants are telling us to avoid it in…
asked 2021-01-20T16:13:05.273+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(70.4, 78%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
David Beavon
976
Reputation points
commented 2021-04-26T20:29:35.31+00:00
Armando Lacerda
11
Reputation points MVP
1 answer
Description does not appear as a tooltip in Pivot Tables
As per the Microsoft Documentation for Azure Analysis services, Once we put in Description in Tables/Columns/Measures, if an end-user places the cursor over this column in the field list, the description appears as a tooltip. I did as…
asked 2021-04-01T23:23:24.027+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, 31%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Ravi Kosuri
6
Reputation points
commented 2021-04-16T18:09:40.167+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(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saurabh Sharma
23,791
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure Analysis Services Connection over HTTPS
Is there a way to set up Azure Analysis Services to accept connections over HTTPS with basic authentication? This was easily done with SSAS hosted on a virtual machine and IIS in the past.
asked 2021-04-15T17:22:38.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(294.40000000000003, 42%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDZ%3C/text%3E%3C/svg%3E)
Daniel Zielinski
21
Reputation points
accepted 2021-04-16T14:56:42.703+00:00
Daniel Zielinski
21
Reputation points
1 answer
Expression folder missing in Tabular Model Explorer
Cant find Expression folder in the Tabular Model Explorer (Screen shot attached) Also unable to open power query editor to write custom query for table.
asked 2021-04-13T03:43:40.517+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(259.20000000000005, 61%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Abhay Sudhakaran
1
Reputation point
commented 2021-04-13T22:43:26.093+00:00
Saurabh Sharma
23,791
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Migrate Ssas cubes to azure Analysis Services
Hi Everyone, I need to migrate Ssas multi dimensional cubes to Azure Analysis services. Do I need to convert to Tabular models before migrating ? Please guide me the best way to migrate to Azure Analysis Services Thank you
![](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(48, 22%, 14%)' 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
Memory caching Issue in Azure analysis services
Hello All, We have our data stored in azure analysis services B1 Tier. Power bi report deployed in a premium workspace is consuming the Model using live query. We are facing issue with AAS that the model is not releasing the memory …
asked 2021-04-08T06:33:36.567+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(6.4, 21%, 10%)' 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)
MuFan
1
Reputation point
answered 2021-04-09T16:52:58.377+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(32, 44%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Samara Soucy - MSFT
5,051
Reputation points
1 answer
Azure AS Model deployment error
I have developed the Azure AS model in Visual studio 2019 and its processing fine from VS. However, when i am trying to deploy to Azure AS server its throwing an error: No mapping between account names and security IDs was done
asked 2021-03-23T18:24:29.457+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(172.8, 2%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERE%3C/text%3E%3C/svg%3E)
rajendar erabathini
616
Reputation points
commented 2021-04-06T07:52:56.007+00:00
PRADEEPCHEEKATLA-MSFT
85,351
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure Analysis services process automation
Hi - Can I automate the processing of the Azure Analysis services cube using Data Integration pipeline in Synapse workspace without using Azure automation runbook or logic apps. Please point me to respective documentation URLS. Also enlighten me on is it…
asked 2021-03-24T17:55:13.113+00:00
rajendar erabathini
616
Reputation points
commented 2021-03-30T03:09:08.427+00:00
Nandan Hegde
31,346
Reputation points MVP
3 answers
One of the answers was accepted by the question author.
impersonation for azure analysis services
Hi - I have deployed the Azure tabular model from Visual studio 2019. I am connecting to Azure Synapse SQL Pool in Data source in legacy mode i.e. it uses SQL query format to get the data from source instead of Power Query. I have to use it since i am…
asked 2021-03-25T13:20:57.453+00:00
rajendar erabathini
616
Reputation points
answered 2021-03-26T05:58:25.37+00:00
rajendar erabathini
616
Reputation points
2 answers
One of the answers was accepted by the question author.
Multiple copies of Azure analysis services Cube
Hi - I need some recommendation in Azure SSAS We have Power BI dashboards connected to Azure Analysis Service model. Our Cube refresh everyday, however sometimes cube may fail while processing due to invalid/bad data. Since we don't have…
asked 2021-03-17T14:39:14.527+00:00
rajendar erabathini
616
Reputation points
accepted 2021-03-25T07:02:07.347+00:00
rajendar erabathini
616
Reputation points
2 answers
One of the answers was accepted by the question author.
MDX Cubes to Azure
We are planning to move on-prem SQL MDX Cubes to Azure. What options do we have in Azure as equivalent in Azure. I heard that Azure Analysis Services does not support MDX Cubes. Please help
![](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(96, 71%, 19%)' 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)
1 answer
One of the answers was accepted by the question author.
Azure Analysis services - Data source change
HI - We have Azure AS tabular model which points to On premise SQL server. As part of our cloud migration i was trying to change the Datasource to point to Synapse Analytics database. We have migrated all the on premise tables to Synapse pool with the…
asked 2021-03-22T15:44:00.567+00:00
rajendar erabathini
616
Reputation points
accepted 2021-03-24T16:47:58.267+00:00
rajendar erabathini
616
Reputation points
0 answers
Unable to Slice from Outrigger Dimensions in Azure Analysis Services
In Azurd Analaysis services, I see an issue while querying data (Pivot Table) from an Outrigger Dimension, for example DimAddress have DimState and DimZip as Foreign keys from different dimensions and when I using the above dimensions as filters, the…
asked 2021-03-22T21:30:43.863+00:00
Ravi Kosuri
6
Reputation points
commented 2021-03-24T01:41:05.067+00:00
Samara Soucy - MSFT
5,051
Reputation points
1 answer
One of the answers was accepted by the question author.
KQL query issues with dynamic and datetime
I’m having some issues with KQL queries where I want to retrieve the value of some custom dimension that I’ve logged in custom events. That custom dimension contains a datetime value, and I want to write a query which does something with that datetime…
asked 2021-03-19T09:15:26.94+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, 55.00000000000001%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBD%3C/text%3E%3C/svg%3E)
Bogdan Dragu
46
Reputation points Microsoft Employee
accepted 2021-03-23T19:23:47.87+00:00
Bogdan Dragu
46
Reputation points Microsoft Employee
1 answer
Azure Analysis services Processing failed
Azure Analysis services Processing failed (in memory mode) with message the remote server returned an error: (400) bad request. we are using Azure Synapse workspace sql pool as data source Please note..it is failing after loading after 40-50% data.
asked 2020-11-23T10:27:20.127+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(281.6, 31%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECP%3C/text%3E%3C/svg%3E)
Chandra Prakash Matam
21
Reputation points
answered 2021-03-19T08:09:20.377+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(6.4, 54%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Rahul Metangale
106
Reputation points
1 answer
One of the answers was accepted by the question author.
only sample data available
hi, i just started a azure analysis service afterwards i set up a connection to a local data gateway, connected to our internal postgres database state is online and green, so it's fine. as you see in the picture, i cannot add any model.…
asked 2021-03-04T07:52:26.107+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(83.2, 43%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Tobias Daucher
21
Reputation points
commented 2021-03-04T09:06:46.127+00:00
Tobias Daucher
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Analysis Services Incremental Loading Approach
What we are using: Azure Synapse Azure Analysis Services Azure Logic Apps Azure Data Factory What we want: Daily incremental extraction from an Azure Synapse external table to an Azure Analysis Services database. This is insert only,…
asked 2020-09-15T21:00:01.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(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 2021-03-02T09:56:56.56+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(195.2, 94%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Shantanu Rajebhosale
1
Reputation point