Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
444 questions
0 answers
Azure Analytics software audit - list of registry entries checked
A quick background summary to put this query into context. Our cyber insurance requires that there is no (manufacturer/supplier/third party) unsupported software on any of our 1000+ servers. I have run an Azure Analytics query to search for 3…
asked 2023-02-10T11:49:26.8+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(144, 21%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Duckfield, Sam D
0
Reputation points
commented 2023-02-15T11:37:09.3166667+00:00
ShaikMaheer-MSFT
38,401
Reputation points Microsoft Employee
2 answers
Azure Analysis Services - error when processing blob storage data
Hello, I'm facing an issue regarding access to Blob Storage Container from Azure Analysis Server Instance. I've created a tabular model that pulls the data from Blob Container, but when I'm trying to process the data from the container in SQL Server…
asked 2021-10-01T12:44:18.527+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, 40%, 20%)' 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)
Matthew
121
Reputation points
edited an answer 2023-02-11T00:05:00.36+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(185.6, 95%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYL%3C/text%3E%3C/svg%3E)
Yan Linn Naing
0
Reputation points
0 answers
Can we convert R script to M code (Power Query)
As we are having few scripts in R which we are consuming in another scope, as per the new scope that needs be migrated to M (Power Query). If so, are there any best practices to migrate existing scripts to M code. Do we have any tools that can be used…
asked 2023-01-27T12:38:18.8+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, 1%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Manohar Kondragunta
0
Reputation points
commented 2023-02-10T04:27:15.64+00:00
AnnuKumari-MSFT
32,161
Reputation points Microsoft Employee
3 answers
Azure Analysis Services - Unable to delete an existing database using SSMS
Hi All, I have a database in analysis server which I want to delete completely. I guess that the database is corrupted somehow as I'm not able to connect that model to powerbi or do any operation on that model (simple operations too..for instance…
asked 2022-10-29T15:06:10.857+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, 14.000000000000002%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDU%3C/text%3E%3C/svg%3E)
D U Maheswara Rao
1
Reputation point
answered 2023-02-03T13:43:36.4066667+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, 62%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Sanjaykumar Gajwani
0
Reputation points
1 answer
How to export list of dependencies from a tabular cube?
I have my cube already deployed: I am looking to map the dependencies of the cube; that is, the name of tables / data objects being used in these cubes. How can I output that list?? I would like to get the full list of all the sources like:
asked 2023-01-23T13:45:38.91+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, 46%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
ovonemty
56
Reputation points
edited the question 2023-02-02T11:02:48.2866667+00:00
PRADEEPCHEEKATLA-MSFT
85,586
Reputation points Microsoft Employee
0 answers
How to create a gateway from azure analysis server to on prem server? The azure analysis server is getting data from on-prem server but it is not working as expected.
How to create a gateway from azure analysis server to on prem server? The azure analysis server is getting data from on-prem server but it is not working as expected. While refreshing any tables inside the cube, its throwing error.
asked 2023-01-23T12:30:58.8433333+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(41.6, 20%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Kumar, PPrabhat
1
Reputation point
commented 2023-01-27T05:17:14.58+00:00
PRADEEPCHEEKATLA-MSFT
85,586
Reputation points Microsoft Employee
2 answers
Unable to upgrade tabular level to compatibility level to 1500
We are in the midst of upgrading our tabular models compatibility level to 1500. They are currently on 1200 and they are on SSAS not Azure Analysis Services. We were successful in converting most of them to 1500 and deploy them.. However, we are not able…
asked 2020-05-20T15:20:30.617+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(48, 84%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Nama, Srikanth
1
Reputation point
edited the question 2023-01-24T18:19:01.5466667+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,442
Reputation points Microsoft Employee
0 answers
Use last interactive login profile to connect to Azure Analysis Service with Adomd client
I successfully connected to my org AAS database with Adomd .NET client library using Microsoft.AnalysisServices.AdomdClient; Console.WriteLine("Starting program..."); AdomdConnection adomdConnection = new…
asked 2022-12-22T01:10:19.347+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(144, 32%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHN%3C/text%3E%3C/svg%3E)
Huy Nguyen
21
Reputation points
edited the question 2023-01-24T04:00:30.0633333+00:00
KranthiPakala-MSFT
46,442
Reputation points Microsoft Employee
1 answer
azure devops - Deploy SSAS tabular cube model error
Hi, In Azure Devops, we created SSAS deployment pipeline in order to automate the cube deployment. As part of this, in the release pipeline, added a task Deploy SSAS tabular cube model. ran into an error that path doesn't…
asked 2023-01-13T00:00:52.67+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, 10%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Prathibha Kambhampati
21
Reputation points
commented 2023-01-24T01:03:53.23+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(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT
29,036
Reputation points Microsoft Employee
2 answers
Connecting Azure Analysis Service with Azure Blob Storage
Hi, I have free AAS account and Blob Storage. Have uploaded some data (data integrity ensured) in Blob Storage and now wants to connect it with AAS to create tabular models for Power BI reporting. However, in AAS, I don't see an option to…
asked 2021-03-03T08:11:11.047+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(262.40000000000003, 80%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Jasmine AHLAWAT
1
Reputation point
answered 2022-12-30T12:50:24.337+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(80, 51%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFG%3C/text%3E%3C/svg%3E)
Franco Galindo
1
Reputation point
4 answers
How to add a column to AAS table, in this situation?
We have an AAS cube that - appears to be, based on underlying Views in the Azure SQL Database I can add a column to a View fine in SQL, but I'm unsure how to promote that column to the AAS Cube. Is there any sort of documentation? I'd love to…
![](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(252.8, 39%, 34%)' 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)
1 answer
One of the answers was accepted by the question author.
Authentication types supported from Azure AS to Azure SQL
Dear Experts, as part of a migration project I am trying to connect Azure AS Tabular to Azure SQL through Database Gateway and Private Endpoint. (This method was actually recommended by Microsoft experts to be able to use only Private Endpoint…
asked 2022-12-02T16:51:14.99+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, 74%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Barnabas Sipos
21
Reputation points
accepted 2022-12-14T11:40:39.113+00:00
Barnabas Sipos
21
Reputation points
1 answer
Azure Analysis Services - Billing information based on Pause and resume
Hi There, Hope someone can help me with the question I have. We are planning to move SSAS to Azure AS. But there is a bit of confusion regarding the cost. So would like to know how the cost works if we Pause and Resume the service. For…
asked 2022-12-07T00:58:17.64+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(102.4, 43%, 19%)' 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)
Sumayya Sayed
1
Reputation point
commented 2022-12-09T18:01:34.11+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(211.20000000000002, 43%, 30%)' 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)
Monalla-MSFT
12,846
Reputation points
1 answer
One of the answers was accepted by the question author.
Excel connectivity Issue for AAS
Hey, Some of the users are able to access AAS via excel and some of us are getting the below error: Can anyone help us identify what the error is about and what is the resolution for it? Note: The users unable to access via excel are…
asked 2022-11-10T13:12:04.833+00:00
Nandan Hegde
31,511
Reputation points MVP
accepted 2022-12-09T11:19:27.767+00:00
Nandan Hegde
31,511
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Azure Analaysis service error
When importing data using native query, we are getting "native queries aren't supported by this value" my understanding is ODBC allows using native queries. Please let me know whether native query work with ODBC in Azure analysis…
asked 2022-12-07T04:43:17.673+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(35.2, 45%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP3%3C/text%3E%3C/svg%3E)
Pavankumar-3526
306
Reputation points
accepted 2022-12-08T03:18:49.78+00:00
Pavankumar-3526
306
Reputation points
1 answer
One of the answers was accepted by the question author.
Visual Studio Licence for Azure Analysis Services
I'm working in a big company as a BI developer. I'm new in Analysis Services but when I unstood it right, I need a Version of Visual Studio to use SSDT. I only want to use the Visual Studio for Azure Analysis Services. Do I have to pay for the Visual…
asked 2022-12-05T15:54:06.153+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(41.6, 97%, 14%)' 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)
de Bernardo, Mark
21
Reputation points
accepted 2022-12-06T06:22:06.297+00:00
de Bernardo, Mark
21
Reputation points
1 answer
Process AAS Model memorry error
Hello, please I really need your help, each time I try to process my model(VS) I get this error Failed to save modifications to the server. Error returned: 'There's not enough memory to complete this operation. Please try again later when there may…
asked 2022-11-30T18:24:30.627+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(150.4, 81%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBU%3C/text%3E%3C/svg%3E)
Back up
6
Reputation points
commented 2022-12-03T01:18:05.203+00:00
Bhargava-MSFT
29,036
Reputation points Microsoft Employee
1 answer
Odbc.Query on AAS through Visual Studio (An M partition uses a data function which results in access to a data source different from those defined in the model)
Good afternoon, Some of our developers are facing a very annoying issue when working with Visual Studio (2019) They create a simple AAS cube where they define an ODBC Teradata connection , let's say "Odbc/authentication=td2;dsn=BIPDEV" …
asked 2022-12-01T17:21:08.38+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(124.80000000000001, 81%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
MARTIN PEREZ Miguel
41
Reputation points
commented 2022-12-02T20:49:24.177+00:00
Bhargava-MSFT
29,036
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Native Query in Analysis Services with ODBC
Hi, We are trying to import data by using a native query in Visual Studio ; we use on our side ODBC for our Teradata servers Problem is when we try to create the expression, we receive a popup saying that "native queries aren't supported by…
asked 2022-10-17T19:52:22.687+00:00
MARTIN PEREZ Miguel
41
Reputation points
accepted 2022-12-01T17:11:47.54+00:00
MARTIN PEREZ Miguel
41
Reputation points
1 answer
AAS refresh failure via ADF
HI All, I am following the below blog to process AAS via managed identity: https://medium.com/ricoh-digital-services/process-azure-analysis-services-models-with-azure-data-factory-v2-d7c6288f352c The only change that i implemented is rather…
![](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(291.2, 27%, 38%)' 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)