Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
1 answer
One of the answers was accepted by the question author.
What is the best way to transform raw data coming from synapses to Power BI
I am into a project to bring all data from F&O to synapses and then load to power BI to create multiple dashboard for different modules and it will be used by different companies . So I would like to understand what will be the best platform to…
asked 2023-07-19T10:21:43.7766667+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, 86%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Athira Reghuraman
60
Reputation points
commented 2023-07-24T09:55:43.6966667+00:00
Athira Reghuraman
60
Reputation points
1 answer
One of the answers was accepted by the question author.
Analysis service error
Did anyone notice this error while refreshing the azure analysis services? Error Details<br/><p style='color:red'>[{"message":"Retry attempts for failures while executing the refresh exceeded the retry limit set on the…
asked 2023-07-14T15:29:47.13+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(265.6, 9%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB4%3C/text%3E%3C/svg%3E)
Bharath-4205
80
Reputation points
accepted 2023-07-24T05:18:42.52+00:00
Bharath-4205
80
Reputation points
1 answer
One of the answers was accepted by the question author.
analysis services native query
Hello, when trying to import the data using the native query, we are getting an error "native queries aren't supported by this value". We are using ODBC here. my understanding is ODBC allows native queries. Appreciate your inputs here
asked 2023-07-14T15:38:46.7433333+00:00
Bharath-4205
80
Reputation points
accepted 2023-07-24T05:18:27.4966667+00:00
Bharath-4205
80
Reputation points
1 answer
How to connect to Azure Serverless Pool from On-Prem SSAS Tabular using Visual Studio
Hi, We have an On-Prem SSAS Tabular database and we need to be able to setup a new datasource to an Azure Serverless SQL Pool. I tried all the different providers but there doesn't seem to be a way to connect. Using SSMS, I can connect using Azure…
asked 2023-07-10T13:23:10.4766667+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, 47%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Cabral, Scott
21
Reputation points
edited the question 2023-07-21T09:28:39.14+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(140.8, 78%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tianyu Sun-MSFT
28,421
Reputation points Microsoft Vendor
1 answer
Alternative method to Add-AzAnalysisServicesAccount for connecting to Azure Analysis Service using MSAL
What is an alternative method to Add-AzAnalysisServicesAccount module for connecting to Azure Analysis Service from a PowerShell task using MSAL? We are currently using the Add-AzAnalysisServicesAccount module which internally uses ADAL, however, as ADAL…
asked 2023-07-14T05:20:03.63+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(304, 77%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Rajmohan Ponnurangam
0
Reputation points
edited an answer 2023-07-20T18:46:58.54+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)
BhargavaGunnam-MSFT
28,076
Reputation points Microsoft Employee
1 answer
How to get the Schema of list of Parquet files in a folder
Hi All, I have to Create a file which will have the Parquet File name and its Schema into a CSV file. I can use Metadata and Child Items to get the list of files in a folder. But getting the Schema of each file is where i am stuck can you please suggest…
asked 2023-07-14T16:58:25.4833333+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, 32%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJN%3C/text%3E%3C/svg%3E)
Jaganathan, NK. (Naveen Kumar)
0
Reputation points
commented 2023-07-20T16:52:23.22+00:00
ShaikMaheer-MSFT
38,301
Reputation points Microsoft Employee
1 answer
How to see the initial configuration of an Azure resource
Hi, we created an instance of analysis services, but we can't find what the initial configuration was when looking at the creation JSON in the activity log. How would we find what the initial configuration would have been?
asked 2023-07-11T18:55:45.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(147.20000000000002, 12%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Richard Duane Wolford Jr
206
Reputation points
answered 2023-07-11T21:27:59.5766667+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, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache
20,106
Reputation points
0 answers
How come for some people their name is added to the AAS model like xxxx_name_xxxxx when they deploy the AAS model?
It seems that for some people when they deploy an AAS model to the server their name is added to the model name like xxxxxx_name_code instead of just publishing the model name xxxxxx. Because of this there seem to be multiple model versions rather than…
asked 2023-06-21T14:51:29.4133333+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, 68%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ8%3C/text%3E%3C/svg%3E)
JKmag-8992
0
Reputation points
commented 2023-07-10T06:09:20.29+00:00
PRADEEPCHEEKATLA-MSFT
81,646
Reputation points Microsoft Employee
1 answer
How can I automate partition creation in Azure Analysis Services without using SPN Certificates?
I am currently using a setup where I create partitions in Azure Analysis Services database tables using Automation Runbooks, where we connect to AAS using SPN Certificates. Since Azure will be discontinuing the use of Certificates for authentication from…
asked 2023-06-14T05:41:23.8233333+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, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
commented 2023-07-06T12:06:29.1466667+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, 39%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SwathiDhanwada-MSFT
18,041
Reputation points
1 answer
Processing Of Azure Analysis Server Failed
Hi, we are trying to refresh the azure analysis server using the Azure Logic apps. While I am trying to process i am getting the following error Error Details<br/><p style='color:red'>[{"message":"Retry attempts for failures…
asked 2023-06-30T13:01:37.0666667+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(28.799999999999997, 27%, 12%)' 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)
MAHESWAR KESS
0
Reputation points
answered 2023-07-03T21:06:31.3+00:00
BhargavaGunnam-MSFT
28,076
Reputation points Microsoft Employee
1 answer
Processing Of Azure Analysis Server Failed
we are trying to refresh the azure analysis server using the Azure Logic apps. While I am trying to process i am getting the following error. {"message":"Retry attempts for failures while executing the refresh exceeded the retry limit set…
asked 2023-01-31T07:05:06.5666667+00:00
MAHESWAR KESS
0
Reputation points
commented 2023-06-30T16:03:03.4766667+00:00
BhargavaGunnam-MSFT
28,076
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Can't connect to azure analysis services with python and azure function using azure active directory.
Hi, iam trying to connect azure analysis services to query a tabular model using an azure function which is coded with python. The authorization is working through azure active directory and i setup oauth in my python script with token requests. The…
asked 2023-05-10T12:15:18.22+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(182.40000000000003, 46%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGK%3C/text%3E%3C/svg%3E)
Gökhan Demirci
40
Reputation points
commented 2023-06-23T09:02:50.5633333+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(188.79999999999998, 62%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
SADHANA ALUGURI, GFPD
0
Reputation points
0 answers
How to transform D365F&O data before connecting to power BI from synapses
Hi , I have created view in Azure synapses using CDMUtilSolution for data's exported from D365 F&O . Please help me understand how can I transform these data's and model this data in a better and cost effective way before loading and transforming…
asked 2023-06-16T09:03:29.9733333+00:00
Athira Reghuraman
60
Reputation points
edited the question 2023-06-19T14:41:46.4133333+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(115.19999999999999, 10%, 21%)' 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)
MuthuKumaranMurugaachari-MSFT
22,256
Reputation points
1 answer
Azure Analysis Services with Power BI Architecture
Hello, We have around 50 power bi reports connected Live to On-Premise Analysis Services, and we are migrating to Azure Analysis Services. When it was on premise it didn't matter if it was Live or import because we are were not charged by hour or…
asked 2023-06-10T11:39:16.76+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(160, 75%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJE%3C/text%3E%3C/svg%3E)
John Elmasry
0
Reputation points
commented 2023-06-12T05:56:51.2533333+00:00
John Elmasry
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Tabular model creates two databases using visual studio
Hello Experts, When I use the visual studio to deploy my tabular model it creates two databases. It looks like both databases have the exact same copies. I am not sure which one to use. Can you give me some insights on this. Do we know why there two…
asked 2023-06-02T14:19:31.4266667+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(19.2, 77%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC6%3C/text%3E%3C/svg%3E)
ChoudaryR-6454
120
Reputation points
accepted 2023-06-07T19:21:49.4+00:00
ChoudaryR-6454
120
Reputation points
1 answer
How to deploy and refresh tabular model with AAD datasource
I have a customer looking to deploy an Azure Analysis Services (AAS) tabular model using Azure DevOps. However the underlying database is a Synapse Lake Database which does not support SQL authentication. All the examples seem to be for sql auth. They…
asked 2023-06-05T09:04:34.8566667+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, 19%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDO%3C/text%3E%3C/svg%3E)
Damien O'Connor
0
Reputation points Microsoft Employee
answered 2023-06-06T20:18:16.9333333+00:00
BhargavaGunnam-MSFT
28,076
Reputation points Microsoft Employee
1 answer
Azure Analysis Services S9 pricing tier is missing
Hi , I had recently upgraded the pricing tier of my Azure analysis services from S9 to S9v2 to check the performance. Since S9v2 incurs more cost , i wanted to scale down back to S9. But now the S9 pricing tier is not at all available in Azure portal…
asked 2023-05-18T05:28:38.3466667+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, 73%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBJ%3C/text%3E%3C/svg%3E)
Binu Joseph (MINDTREE LIMITED)
0
Reputation points Microsoft Vendor
commented 2023-05-31T00:28:31.39+00:00
BhargavaGunnam-MSFT
28,076
Reputation points Microsoft Employee
1 answer
How to stop cube processing that was triggered from ADF web activity
I have created ADF pipeline to process tabular model in AAS using web activity (By referring the url https://github.com/furmangg/automating-azure-analysis-services/blob/master/ADFv2/ProcessAzureAS.json). As web activity is an asynchronous call to process…
asked 2023-05-08T15:31:09.4533333+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(230.39999999999998, 97%, 32%)' 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)
Poornima
21
Reputation points
commented 2023-05-29T13:37:10.18+00:00
ShaikMaheer-MSFT
38,301
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
processing aas tabular model in visual studio results in two tabular databases with a model in each
Hi, when i build, deploy and process my Azure Analysis Services Tabular Model in Visual Studio and connect PowerBI to it, i always see two Tabular Databases. One has the normal expected name and the other one has a string attached to it. It looks like a…
asked 2023-05-24T14:46:20.19+00:00
Gökhan Demirci
40
Reputation points
accepted 2023-05-29T10:04:43.55+00:00
Gökhan Demirci
40
Reputation points
1 answer
One of the answers was accepted by the question author.
Criar partições no modelo do Azure Analysis Services via SMSS
Estou tentando criar partições de uma tabela usando o modelo do Azure Analysis Services, porém me retorna o seguinte erro: " Failed to save modifications to the server. Error returned: 'An error occurred during On-Premise Gateway related activity.…
asked 2023-05-12T18:50:55.65+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(310.4, 46%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
Loren Rana da Silva Oliveira
41
Reputation points
accepted 2023-05-22T15:11:27.5966667+00:00
Loren Rana da Silva Oliveira
41
Reputation points