Unable to refresh Azure Analysis Services when dtabase type is set to full.
The remote server return an error: 400 Bad Request when refresh type is set to full for the database.
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…
"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."
One of the users receive this error. is this issue at our end or at microsofts ?
How to use tabular model Dax query in Azure Pipeline?
I have a tabular model named ADM, which contains multiple tables. I need to retrieve data from it using a DAX query, structured as follows: DAX EVALUATE SUMMARIZECOLUMNS( 'Fiscal Week Calendar'[Fiscal Year], 'Fiscal Week Calendar'[Fiscal…
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
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…
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…
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…
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?
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???

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…

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…
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…
I would like to know how to configure row-level security in the model,
Marsden-Holdings underlying dataset tow-level security
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.
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…
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…
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…
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…
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…