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.
azure analysis services - models
In azure analysis services, how to view permissions set on models using Java REST api? Any other alternative approaches/suggestions are welcome.
asked 2021-02-17T21:30:13.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(236.8, 19%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPH%3C/text%3E%3C/svg%3E)
Prashantha Hosapattana
26
Reputation points
commented 2021-02-24T16:21:30.283+00:00
Prashantha Hosapattana
26
Reputation points
1 answer
One of the answers was accepted by the question author.
Connecting to Azure Analysis Services using python
I am trying to query my powerbi metadata stored in Azure Analysis services through python. I have used Nuget package and loaded the dll "Microsoft.AnalysisServices.AdomdClient" to my root folder (RHEL Linux), when I tried to execute the below…
asked 2021-02-16T07:05:55.547+00:00
Rajasekar Nonburaj
111
Reputation points
commented 2021-02-23T18:31:45.55+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
1 answer
Not able to connect azure analysis service using sevice principal in SSIS
I am receiving following message “Test connection failed because of an error in initializing provider. The following system error occurred: “ (Without any error description) while trying to connect Azure Analysis Services in SSIS using service principal…
asked 2021-02-11T13:30:59.747+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, 33%, 32%)' 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)
Satish Sridharan (Cognizant Worldwide Limited)
1
Reputation point
commented 2021-02-19T13:17:21.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(201.6, 79%, 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)
SQLDev2021
1
Reputation point
0 answers
Error connecting to Azure Analysis Services using Linked Server in SSMS
I created a Linked server in SSMS , to connect to Azure analysis Services cube & query some data. While Configuring the Linked Server, I set it up for MFA. When I run the Query using the Linked server, I am prompted with MFA , and I choose…
asked 2021-02-19T02:52:16.927+00:00
SQLDev2021
1
Reputation point
commented 2021-02-19T08:57:41.21+00:00
PRADEEPCHEEKATLA-MSFT
85,351
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure Analysis Service Data Refresh Performance
Hi, I want to understand what is the load on the server when I perform a Data Refresh for a few tables in a DB in Azure Analysis Service? What are the metrics that I need to monitor to understand a)is the server overloaded b)is the server having…
![](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(140.8, 95%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
How to automate Azure Analysis tabular model refresh every hour today in 2021?
We have Azure Analysis service provisioned and have deployed a SSAS Tabular model which has a Star schema in it . Now we want to know how automate the processing . When I look up on the internet ,it seems there are 3 ways not sure how to select which…
![](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, 28.999999999999996%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
How to fetch fields from AAS data model in java?
Hello there, I am Nilesh, exploring Azure analysis service for my project. For that, I have created demo azure free account and able to create demo AAS and integrate it with SSMS/Excel to check the imported data model with its fields. I…
asked 2021-02-10T06:53:25.287+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, 4%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENP%3C/text%3E%3C/svg%3E)
Nilesh Prajapati
21
Reputation points
accepted 2021-02-12T09:31:20.667+00:00
Nilesh Prajapati
21
Reputation points
1 answer
AAS model credential expire
Hi Team, We are using AAS with ADLS Ver1 as a data source. our model got error out while processing as refresh credentials is expired. could you please provide or guide any mechanism to not expire the refresh token? AAS Model - Refresh token expire and…
asked 2021-02-05T12:23:18.787+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, 54%, 10%)' 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)
sunil gupta
1
Reputation point
commented 2021-02-12T05:49:00.763+00:00
PRADEEPCHEEKATLA-MSFT
85,351
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Calculation groups in SSAS Tabular model not working
I m following the below article to create MTD, QTD and YTD (Time intelligence) calculation group in SSAS Tabular model in VS and then deploying it to Azure AS. calculation group : CALCULATE(SELECTEDMEASURE(), DATESMTD(DimDate[Date])) …
asked 2021-02-10T04:09:23.957+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, 56.00000000000001%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mudassar A
486
Reputation points
commented 2021-02-10T23:24:34.413+00:00
Mudassar A
486
Reputation points
1 answer
One of the answers was accepted by the question author.
How to get list of roles and members in an Azure Anlysis service via Powershell
We want to get the list of roles and members existing in an Azure Analysis services via Powershell. Is it possible? https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-powershell Based on these list , I did not get any…
![](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)
2 answers
Azure Analysis Services and Excel - Maximum Page Size of the Storage Object
I am unable to query an Azure Analysis Services model from Excel. I receive the following error: Memory error: A record (99909 bytes) was encountered that exceeds the maximum page size of the storage object (65528 bytes). Is there a setting I can use…
![](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(76.8, 89%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGL%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Issue when processing tabular model
I have something strange from my point of view since 2 days with my tabular model deploy in Azure. If i process a table with the User Interface, there are no problem and everything work fine, but if i try the same with a TMSL script, i have the same…
asked 2021-02-05T12:21:51.25+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(57.599999999999994, 1%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECF%3C/text%3E%3C/svg%3E)
Cedric FK_finelog
206
Reputation points
accepted 2021-02-08T11:22:17.367+00:00
Cedric FK_finelog
206
Reputation points
2 answers
Change the Name of an Azure Analysis Services Data Source
I have been trying to change the name of an Azure Analysis Services data source using Visual Studio, but to no avail. Is it even possible to change the name of an AAS data source once it has been created? If so, how?
asked 2020-11-18T16:03:57.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(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
answered 2021-02-05T11:48:03.867+00:00
Cedric FK_finelog
206
Reputation points
1 answer
Azure Analysis Services Rolling Weekly Partitions
What is the best way to create rolling weekly partitions for Azure Analysis Services? We would like to be able to process the most recent week of data.
asked 2021-01-26T02:23:22.61+00:00
James H. Robinson
161
Reputation points
commented 2021-02-02T17:31:26.803+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
1 answer
One of the answers was accepted by the question author.
How to connect to Azure Analysis Services from java or other languages and execute DMV queries without using SSMS or MSMDPUMP.dll
My requirement is to connect to Azure analysis services and retrieve tabular model's metadata. I am able to connect to this service from SSMS (Sql server management studio) and execute DMV queries. I would like to do this programmatically. What options I…
asked 2021-01-16T11:31:26.75+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, 4%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Sibi Narayanaswamy
41
Reputation points
accepted 2021-02-02T14:20:04.013+00:00
Sibi Narayanaswamy
41
Reputation points
2 answers
Partition Processing - Tabular Model in Azure
We have a Tabular Model that exists in Azure - processed multiple times a day to catch intra-day transactions. For simplicity sake I will denote the Table Structure as: FactTable1 (Order Transactional) FactTable2 (Detail Transactional) DimTable1 …
asked 2021-01-27T21:58:25.697+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(67.2, 46%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Derek Price
26
Reputation points
commented 2021-02-01T09:03:12.37+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(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Lukas Yu -MSFT
5,821
Reputation points
1 answer
One of the answers was accepted by the question author.
Powershell to identify whether the data source is legacy one
Hello. Is there any particular property via which we can identify through powershell whether the data source within an AAS is a legacy one ? Legacy : ConnectionString : Persist Security Info=false;User…
asked 2021-01-27T04:57:00.613+00:00
Nandan Hegde
31,346
Reputation points MVP
accepted 2021-02-01T03:02:42.047+00:00
Nandan Hegde
31,346
Reputation points MVP
1 answer
SSIS Analysis Processing Task Error: Exception has been thrown by the target of invocation.
Hi I'm trying to process an object (Process Full) in the Azure Analysis Services through Analysis processing task and getting below error when executing the SSIS package. Exception has been thrown by the target of invocation. I'm able to test the…
asked 2021-01-26T00:05:09.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(131.20000000000002, 78%, 22%)' 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)
Suresh Veesam
21
Reputation points
commented 2021-01-29T06:41:07.377+00:00
Lukas Yu -MSFT
5,821
Reputation points
1 answer
Able to deploy but unable to process the AS tabular model on Azure Analysis service
Able to deploy but unable to process the AS tabular model on Azure Analysis service . New AS service provisioned in Azure with the below compatibility I get the below error from VISUAL STUDIO Error message ------ Build started:…
asked 2021-01-25T17:51:35.11+00:00
Mudassar A
486
Reputation points
commented 2021-01-25T23:04:47.237+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, 70%, 26%)' 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)
MartinJaffer-MSFT
26,061
Reputation points
1 answer
How to set dynamically the database connection string in a tabular model
I am using configurations for deploying the same tabular model to different clients (same model, same db structure, only difference is the db connection string). Unfortunately the connection string is not part of the configuration properties. Is there…
asked 2021-01-06T12:57:36.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(256, 7.000000000000001%, 34%)' 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)
Ralf Mark
1
Reputation point
commented 2021-01-18T01:32:50.673+00:00
Lukas Yu -MSFT
5,821
Reputation points