Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
472 questions
2 answers
SSAS Development How to fix "Cannot open BIM Model. Localhost server unreachable" ?
Hello everyone ! I've had a weird problem during the last couple of days. I downloaded a SSAS project from Azure to work on it with some people. I set it up to use "Integrated workspace", and I left everything else as default. The first time I…
![](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, 74%, 28%)' 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.
Connect Analysis Services to Azure SQL Server using a secure connection
Hello, I 'm searching for a way to connect Azure AAS to Azure SQL DB without exposing the connection to the public and using "Allow Azure services to connect". Is there a way to do so? Best Regards, Michel
asked 2025-02-06T08:59:59.8066667+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, 61%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Michel Sfeir
40
Reputation points
answered 2025-02-06T13:03:25.5666667+00:00
Michel Sfeir
40
Reputation points
0 answers
Memory spikes in Analysis Services
We've recently been experiencing large memory spikes while processing a few of our tabular models on different Azure Analysis Services instances. There were no major changes to the data, so we were not able to determine why it was happening. The issue…
asked 2025-01-29T18:38:24.27+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, 59%, 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)
Billy Duong
5
Reputation points
commented 2025-02-03T12:28:58.9566667+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(288, 61%, 37%)' 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)
phemanth
13,625
Reputation points Microsoft Vendor
1 answer
How do I delete an Azure Analysis Services tabular model that is in an inconsistent state and cannot be accessed
I have an Azure Analysis Services tabular model that is currently in an inconsistent state and cannot be accessed. If I try to delete it using SQL Server Management Studio, it shows the following error: The Tabular database 'XXXXX' is in an…
asked 2025-01-24T02:12:41.02+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, 63%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
rhei78
0
Reputation points
commented 2025-01-30T13:36:01.32+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(268.8, 8%, 36%)' 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)
Smaran Thoomu
19,875
Reputation points Microsoft Vendor
1 answer
Migrating Azure Analysis Services Tabular model to On-Prem
Hello, We have an Azure Analysis Services tabular model which is planned to be migrated to On-Premises server (SQL Server 2019 or 2022 most probably). Compatibility level of AAS is 1500. Can someone advise if this is possible and point me to any articles…
![](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, 27%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
1 answer
Adding Metadata to an Azure Analysis Services Database
How can metadata be added to a database or cube in Azure Analysis Services? Specifics include adding information such as descriptions, data officer contacts, and data stewards. What steps or methods are available to achieve this?
asked 2025-01-13T12:24:17.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(227.2, 94%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jonas Scheerders
0
Reputation points
commented 2025-01-16T20:43:46.8766667+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(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chandra Boorla
7,960
Reputation points Microsoft Vendor
0 answers
Data Connections - OAuth expires after 60 minutes?
Hi - does anyone know why a Data Connection in Azure Analysis Services configured with OAuth2 expires after 60 minutes? Is there any way of extending the expiry time when you configure a connection???
asked 2025-01-09T14:09:31.7766667+00:00
Andrew Blyth
20
Reputation points
commented 2025-01-10T10:25:18.6933333+00:00
Smaran Thoomu
19,875
Reputation points Microsoft Vendor
1 answer
Why am I getting error unable to sync AZURE SSAS Model Upgrade to Standard Pricing tier?
Hi there, When trying to refresh our AZURE Analysis Services models - we have been getting the error "Unable to sync model X for server X upgrade to standard pricing tier" We are currently on the basic pricing tier B1 , and we only have 2…
asked 2024-12-19T01:25:16.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(211.20000000000002, 2%, 30%)' 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)
DS87
0
Reputation points
commented 2024-12-24T06:38:19.0966667+00:00
AnnuKumari-MSFT
34,011
Reputation points Microsoft Employee
2 answers
Excel pivot connected to SSAS tabular model locking up when filtered on record that no longer exists and also has another large filter
Hello, I found a potential "bug" or performance issue for a specific setup when referencing an analysis services cube via an Excel pivot table. The specific scenario is like the below: You have a pivot table referencing an analysis services…
asked 2024-12-18T19:59:10.02+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, 97%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETR%3C/text%3E%3C/svg%3E)
Ted Rogers
0
Reputation points
commented 2024-12-23T01:04:11.75+00:00
Chandra Boorla
7,960
Reputation points Microsoft Vendor
3 answers
Is there a roadmap for Analysis Services Linked Servers in Azure SQL Managed Instance?
My clients rely heavily on being able to query an Analysis Services Linked Server in SQL Server Enterprise. I'm aware this is not currently possible in SQL MI, which means I can't consider migrating any clients there. I'm not looking for alternative…
![](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(297.6, 26%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
1 answer
I would like to know how to configure row-level security in the model,
Marsden-Holdings underlying dataset tow-level security
asked 2024-12-07T21:19:29.9133333+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(224.00000000000003, 48%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVC%3C/text%3E%3C/svg%3E)
Victor Corral
0
Reputation points
commented 2024-12-10T02:13:37.4366667+00:00
Chandra Boorla
7,960
Reputation points Microsoft Vendor
1 answer
How can I update the data source (Azure Storage) for Azure Analysis Services without using the SQLServer module or the Invoke-ASCmd method, preferably using Python?
I am looking for a way to achieve this using Python. Please suggest any tools, libraries, or approaches that can facilitate this, such as using REST APIs or handling XMLA directly. A step-by-step explanation or references would be greatly appreciated.
asked 2024-12-03T10:34:09.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(3.2, 80%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
T, Charandeep
0
Reputation points
commented 2024-12-09T18:08:25.61+00:00
phemanth
13,625
Reputation points Microsoft Vendor
1 answer
How can I update the data source (Azure Storage) for Azure Analysis Services without using the SQLServer module or the Invoke-ASCmd method?
Can I update the data source (Azure Storage) for Azure Analysis Services (AAS) without relying on the SQLServer PowerShell module i.e using the Invoke-ASCmd method to make the changes? Are there alternative approaches or tools available to update the…
asked 2024-12-02T07:15:54.95+00:00
T, Charandeep
0
Reputation points
commented 2024-12-04T15:04:00.4433333+00:00
Smaran Thoomu
19,875
Reputation points Microsoft Vendor
1 answer
Inquiry about Exported Log Verification on Power BI Service Workspace Reports
Hello everyone, I am exploring ways to verify the exported logs for reports on the Power BI Service workspace. According to the official documentation, does the event ID 92 “File Save Begin” indicate an export log? Thank you for your assistance! Best…
asked 2024-10-22T08:36:48.19+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, 13%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIM%3C/text%3E%3C/svg%3E)
Isuke Motoo
0
Reputation points
edited the question 2024-12-04T11:20:54.6+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, 16%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Rakesh Gurram
11,815
Reputation points Microsoft Vendor
1 answer
Cant create new Analysis Services in D1 or B1 tier in West Europe
I am unable to create new services in D1 or B1 tier in West Europe region. Deployed in S0 West Europe or D1 in UK South went fine. I have also check and we didnt have such thing as quotas/limits for Analysis Services also, so I am not hitting any…
asked 2024-11-14T10:00:35.4933333+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(16, 0%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQD%3C/text%3E%3C/svg%3E)
Quyen Dang
21
Reputation points
commented 2024-11-29T17:00:07.5566667+00:00
phemanth
13,625
Reputation points Microsoft Vendor
2 answers
Azure Analysis Services backup to azure blob storage using User Managed Identity
Hi everyone, I have an azure analysis services that i want to make backups to azure blob storage. The problem is, i am not able to do that since the company policies does not allow to use access keys. Is there any way i can configure the backups…
asked 2024-11-21T16:49:54.0966667+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(169.60000000000002, 52%, 26%)' 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)
Rui Domingos (JTA Consulting S A)
0
Reputation points Microsoft Vendor
commented 2024-11-28T10:05:47.68+00:00
Chandra Boorla
7,960
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Insufficient permissions when I click on Log Analytics or Workbooks
I'm in the Entra Admin Center under Monitoring & health and click on Workbooks I get an error saying "Insufficient permissions" and then showing me this (Subscription-ID cc01... is changed, this is not the one that is shown in the real…
asked 2024-11-12T18:02:09.4366667+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(275.2, 69%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELW%3C/text%3E%3C/svg%3E)
Ludwig Wurmannstätter
20
Reputation points
commented 2024-11-19T09:48:21.72+00:00
Ludwig Wurmannstätter
20
Reputation points
0 answers
Identifying Unused Tables in AAS Cube Over the Last 30 Days
I have a question regarding identifying unused tables in Azure Analysis Services (AAS). In our organization, we’re using AAS, and due to limited storage, our cube refresh is failing. I’ve been tasked with finding a list of tables that haven’t been used…
asked 2024-11-07T16:03:40.6433333+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, 76%, 11%)' 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)
madmax
0
Reputation points
commented 2024-11-19T00:56:57.1966667+00:00
Chandra Boorla
7,960
Reputation points Microsoft Vendor
2 answers
Analysis Service not loading big tables fully from SQL Server
We experience a very strange issue when uploading data from our SQL server to our analysis service, which we are hoping to get a bit of sparring on. Briefly explained, the issue is that simple select queries for our largest tables terminate…
asked 2024-11-13T10:01:00.3866667+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, 95%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Laurids
5
Reputation points
edited a comment 2024-11-14T20:24:23.0233333+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, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
4,510
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
How to use the format string function in the column properties to do custom formatting
Hello, I have a date_key column with data type whole number and formatted as Text as shown below. I want to apply this same logic to the date_key column in another table for my measure to work. I don't remember how to use the custom formatting and…
asked 2023-08-28T17:32:41.98+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(118.4, 88%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Cperer
21
Reputation points
commented 2024-10-18T14:39:12.8266667+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, 89%, 38%)' 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)
Mattias Kuosku
0
Reputation points