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…
Azure Analysis Services
SQL Server 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…
Azure Analysis Services
SQL Server Analysis Services
SQL Server | Other
I would like to know how to configure row-level security in the model,
Marsden-Holdings underlying dataset tow-level security
Azure Analysis Services
Azure Synapse Analytics
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.
Azure Analysis Services
Azure Databricks
Azure Data Factory
SQL Server Analysis Services
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…
Azure Analysis Services
Azure Storage
Azure Databricks
Azure Data Factory
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…
Azure Analysis Services
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
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…
Azure Analysis Services
Azure Blob Storage
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…
Azure Monitor
Azure Analysis Services
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…
Azure Analysis Services
Azure Synapse Analytics
SQL Server Reporting Services
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…
Azure SQL Database
Azure Analysis Services
SQL Server | Other
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…
Azure Analysis Services
SQL Server Analysis Services
Import databricks data using tabular editor
I imported data from databricks to AAS using the Simba ODBC driver but after deploying the model, i can't seem to make the refresh work. I get this error "Failed to save modifications to the server. Error returned: 'Expression in partition…
Azure Analysis Services

How do I create an Azure Analysis Services instance?
How do I create an Azure Analysis Services instance?
Azure Analysis Services
Permission on subscription when creating Azure Synapse workspace
I want to create a workspace subscript on Cosmos-bingads-bi, the website prompts me that I do not have the permission. Where should I apply for the permission?
Azure Analysis Services
Azure Cosmos DB
Azure analysis services Scale out replica cost if I need S8v2 replica for 24hrs a month
Hi All, Can the Azure Analysis services Scale out cube replica be provisioned only at the time of cube processing?
Azure Analysis Services
Simplifying data landscape with Synapse
How can I use Synapse to simplify my data landscape for maintenance and cost, assuming the lake is always a constant? I currently have two environments: Lake - Databricks(ETL) - Power BI Lake - ADF - AzureSQL - Analysis Services - Power BI I'm…
Azure Analysis Services
Azure Synapse Analytics
Error when deleting tables or when modifying column names in the tabular model
Hi, I am using tabular model level 1500. I have a postgres database that is connected to the azure analysis server through an on prem gateway. I have used powerquery to fetch data from the postgres database (via an odbc driver) to the model. I was able…
Azure Analysis Services
Unable to access the Azure Analysis services from Visual studio application
Hello All, I have deployed an Azure Analysis Service and enabled the firewall and Power BI. Users are able to access the Azure Analysis Service from Power BI, but they are unable to access it via Visual Studio from their desktops, receiving a network…
Azure Analysis Services

Analysis Services taking too much time to refresh SSAS tabular model
Hi, I have a data set of somewhere 40M records in SSMS. My tabular model earlier use to get refresh on S1 tier with 25-30 min. But now I'm using S2 tier and even still its refreshing the data at approx 60 min or sometimes failing and showing timeout…