Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
444 questions
1 answer
SSAS Processing Error with no additional details
Hi - when running a Process Full on an SSAS Tabular Model deployed on Azure Analysis Services, I receive the following error message: Failed to save modifications to the server. Error returned: '{"error": {"code":…
asked 2022-08-29T18:18:15.437+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, 92%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBN%3C/text%3E%3C/svg%3E)
Brian Nowak
6
Reputation points
commented 2022-09-06T12:07:47.06+00:00
Brian Nowak
6
Reputation points
1 answer
Sudden performance issues AAS tabular model
Hi! I have a BI question about performance in our tabular model deployed to Azure Analysis Services. Some background: we have a large data model (pricing tier S2) where our business users (around 200 users) view data and build reports (Excel &…
asked 2022-08-24T06:42:53.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(22.400000000000002, 37%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEC%3C/text%3E%3C/svg%3E)
Ella Calais
1
Reputation point
commented 2022-09-01T10:28:40.97+00:00
ShaikMaheer-MSFT
38,401
Reputation points Microsoft Employee
1 answer
Suddenly Slow Azure Analysis Services Tabular Model Process with Data from Azure Data Lake Storage Gen 1
At my organization, we have had a tabular model running in Azure analysis services which pulls data from ADLS Gen 1 for some time (years). Doing a full process daily on the AAS database to refresh the data in the model from the data in ADLS Gen 1…
asked 2022-06-21T15:57:59.937+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, 3%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jared Buschkopf
211
Reputation points
commented 2022-08-30T19:27:32.51+00:00
Jared Buschkopf
211
Reputation points
0 answers
TMSL refresh not completing whereas manual refresh in SSMS completes
We have a fairly large AAS tabular model and the largest fact table is partitioned by month (returns somewhere around 200M records by end of the month. When we process a partition manually through SSMS the "full" process completes in 2-3 hours.…
asked 2021-11-02T16:30:47.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(160, 69%, 25%)' 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)
Ben Dunmire
21
Reputation points
commented 2022-08-30T07:51:02.713+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(156.8, 96%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
S, Bharkavi
1
Reputation point
1 answer
Azure Data Factory Analysis Services API call for adding new partition to tabular model
Is it possible to add new partition with API call to the Analysis service logical server . Someting like: createOrReplace:{ .... "partition": { "name": "Sales2019", "mode": "import", …
asked 2022-08-26T06:16:38.907+00:00
nik.chalkanov
1
Reputation point
commented 2022-08-29T18:09:52.433+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
4 answers
Any possibilities to monitor VM hung status
Hi MS, Is there a way to monitor Azure VM hung status from Azure monitoring or using log analytics? Please suggest. What are the logs that can be viewed using log analytics from a VM perspective. Any application based logs be able to capture…
![](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, 19%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Upcoming breaking changes in the cmdlet 'Add-AzAnalysisServicesAccount'
I have a PowerShell script which create AAS after some check. now during release ,we see warning that "Upcoming breaking changes in the cmdlet 'Add-AzAnalysisServicesAccount'". How to handle this? below is the piece if code where…
asked 2022-08-24T04:45:04.12+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(272, 52%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
Khushboo Dubey (Health)
26
Reputation points
commented 2022-08-24T23:48:06.557+00:00
Khushboo Dubey (Health)
26
Reputation points
1 answer
One of the answers was accepted by the question author.
Provide only read or browse access to user on all models/cube in specific Analysis Service.
I have support Ldap group which was part of Analysis service admin, however we dont want to give full permission and will give only read / browse access on cube for analysis or debugging purposes. We can add them in Read Role for each model 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(211.20000000000002, 17%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
0 answers
Breaking changes in the cmdlet Add-AzAnalysisServicesAccount
I have an Azure Automation Account Powershell Runbook to start or pause an Azure Analysis on a schedule (for example pause from 12:00 AM to 7:00 AM). I use the following commands for getting Creds and Rollout env: $ApplicationCredential =…
asked 2021-02-16T21:54:09.973+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, 36%, 20%)' 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)
AzureLearnChstr
26
Reputation points
commented 2022-08-24T03:38:07.243+00:00
Khushboo Dubey (Health)
26
Reputation points
1 answer
Analysis Services Tabular Refresh errors: The server sent an unrecognizable response.
This started after updating the on-premises data gateway. We reverted back to a previous version of the gateway but are still receiving this error. When we go to refresh a tabular data model the refresh process runs for a time and then the query seems…
asked 2022-08-17T18:59:53.987+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(76.8, 56.00000000000001%, 17%)' 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)
AConfusedUser
66
Reputation points
commented 2022-08-23T23:28:04.083+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,041
Reputation points Microsoft Employee
1 answer
Currency symbol not showing up in Power BI, even though it has been defined in Visual Studio (AAS Model)
Currency symbol for one column is not showing up in Power BI, even though it has been defined and is showing in Visual Studio (AAS Model). Attached the two images.
asked 2022-08-11T09:03:51.427+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(243.2, 28.000000000000004%, 33%)' 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)
Surabhi, Surabhi SBOBNG-PTIY/FDF
1
Reputation point
commented 2022-08-22T21:13:33.353+00:00
Bhargava-MSFT
29,041
Reputation points Microsoft Employee
1 answer
Were to define Azure Analysis Services service account credentials
I try to connect Azure Analysis Services Tabular model to the On-Premise SQL server database Through Azure On Premise Data gateway. Data gateway is connected to analysis services and is shoving green light. SQL Connection succeeds from Azure…
asked 2022-08-17T22:06:40.637+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(3.2, 78%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFV%3C/text%3E%3C/svg%3E)
Fred Viidul
1
Reputation point
answered 2022-08-19T08:57:02.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(256, 57.00000000000001%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFV%3C/text%3E%3C/svg%3E)
Fred Viidul
1
Reputation point
0 answers
MFA Authentication Issues
Hi I am getting below error while trying to use MFA authentication to connect to my Azure Analysis Services server from SSMS. I have tried upgrading the dlls but the error is persistant. =================================== Cannot connect to…
asked 2022-08-12T12:56:49.833+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, 74%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBR%3C/text%3E%3C/svg%3E)
Bundhoa, Ricky
1
Reputation point
commented 2022-08-18T10:40:55.233+00:00
Bundhoa, Ricky
1
Reputation point
1 answer
Moving multiple SQL server data warehouse databases from On premise to Azure
Dear Experts, I am new to Azure. I have few questions please help me. we have one SQL server dw database per each customer on premise for reporting (using SSRS). Each dw database consists few dimension tables, one fact and one staging table. …
asked 2022-06-24T21:21:02.96+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(240, 46%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Sreenivasa Chary Tatikonda
1
Reputation point
commented 2022-08-01T18:55:44.33+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,386
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
How would I update a table in the cube after I've added a new column?
I've added a column to the view that the table in the AAS Tabular model uses as the source. Would I have to go in and add the column to the table in the cube in order for the new column to be processed or will the cube just update based on the update…
![](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, 79%, 13%)' 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)
2 answers
Analysis Services Tabular Model - Processing Data - Error On-Premise Gateway is required to access the data source
Hi, We were working with Analysis Services and a Private Endpoint SQL MI. An On premise Gateway was required for this set up but this was not a full PaaS so removed. In Azure we have removed an On Premise Gateway and deleted the Gateway VM, also…
asked 2022-02-16T13:57:55.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(227.2, 71%, 32%)' 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)
P Johns
16
Reputation points
commented 2022-07-28T10:13:33.77+00:00
Peter Rush
41
Reputation points
1 answer
Set-AzAnalysisServicesServer Invalid backup blob container 'The remote server returned an error: (409) Conflict.'
I have copied some code I found to help me workaround getting automate accounts with Analysis services and runbooks Code can be found here I have a private storage resource with a container and I get the below error. All it is doing is resetting the…
![](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, 0%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKH%3C/text%3E%3C/svg%3E)
1 answer
Kusto: Relop semantic error: SEM0026: The arguments array exceeded the allowed limit (allowed=1,000,000)
Hi Team, I have been using the following query to monitor our Logic Apps. AzureDiagnostics | where Category == "WorkflowRuntime" | where OperationName == "Microsoft.Logic/workflows/workflowRunCompleted" | join…
asked 2022-06-22T12:05:30.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(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' %3EST%3C/text%3E%3C/svg%3E)
Shafeeq TS
1
Reputation point
commented 2022-06-23T18:50:01.207+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, 87%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMU%3C/text%3E%3C/svg%3E)
Mike Urnun
9,786
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
User getting AAS model access error in PowerBI Service
Hello, User is unable to load model data in PowerBI Service. Powerbi is using model built in AAS. Below is the error Underlying error message: AADSTS50057: The user account is disabled. Trace ID: 2df60f0e-a84b-4637-abae-0def89753f00 …
asked 2022-06-22T08:59:33.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(198.4, 3%, 29%)' 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)
Majumder, Manish
136
Reputation points
accepted 2022-06-23T06:34:00.097+00:00
Majumder, Manish
136
Reputation points
1 answer
What is the recommended way to work with Azure Analysis Services cubes for PowerBI?
Hi, I have tried the tabular model extension for Visual studio 2022 and 2019. Both are not working well. For example, the addon for 2022 does not install at all. The extensions for 2019, come with some bugs. When I try to import our Azure…
asked 2022-06-20T15:09:37.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(192, 95%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYR%3C/text%3E%3C/svg%3E)
Øyvind Rogne
1
Reputation point
answered 2022-06-22T17:42:29.637+00:00
HimanshuSinha-msft
19,386
Reputation points Microsoft Employee