474 questions with Azure Analysis Services tags

Sort by: Updated
2 answers

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.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
asked 2025-02-14T05:52:49.05+00:00
Zero Trust Solutions 0 Reputation points
commented 2025-02-18T01:35:02.03+00:00
Chandra Boorla 8,470 Reputation points Microsoft Vendor
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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,313 questions
asked 2025-02-04T10:14:50.5333333+00:00
D2d3d4d5 20 Reputation points
commented 2025-02-14T16:24:07.1266667+00:00
Smaran Thoomu 20,295 Reputation points Microsoft Vendor
2 answers

"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 ?

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,313 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,759 questions
asked 2023-10-25T20:03:28.8633333+00:00
zubaid ahmed 5 Reputation points
commented 2025-02-14T15:11:44.54+00:00
Richard Price 0 Reputation points
1 answer

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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,485 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,258 questions
asked 2025-02-10T01:55:07.49+00:00
BALAN A STEPHEN J 0 Reputation points
commented 2025-02-12T01:32:19.64+00:00
Chandra Boorla 8,470 Reputation points Microsoft Vendor
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

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
asked 2025-02-06T08:59:59.8066667+00:00
Michel Sfeir 85 Reputation points
answered 2025-02-06T13:03:25.5666667+00:00
Michel Sfeir 85 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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
asked 2025-01-29T18:38:24.27+00:00
Billy Duong 5 Reputation points
commented 2025-02-03T12:28:58.9566667+00:00
phemanth 13,800 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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
asked 2025-01-24T02:12:41.02+00:00
rhei78 0 Reputation points
commented 2025-01-30T13:36:01.32+00:00
Smaran Thoomu 20,295 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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
asked 2025-01-20T09:05:08+00:00
Balswam 10 Reputation points
commented 2025-01-23T10:57:28.4266667+00:00
Balswam 10 Reputation points
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?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,817 questions
asked 2025-01-13T12:24:17.8+00:00
Jonas Scheerders 0 Reputation points
commented 2025-01-16T20:43:46.8766667+00:00
Chandra Boorla 8,470 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???

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
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 20,295 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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,313 questions
asked 2024-12-19T01:25:16.54+00:00
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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,313 questions
asked 2024-12-18T19:59:10.02+00:00
Ted Rogers 0 Reputation points
commented 2024-12-23T01:04:11.75+00:00
Chandra Boorla 8,470 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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,485 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,313 questions
asked 2024-10-22T04:36:30.9633333+00:00
Jamie 0 Reputation points
commented 2024-12-10T15:42:58.3333333+00:00
phemanth 13,800 Reputation points Microsoft Vendor
1 answer

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 Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,192 questions
asked 2024-12-07T21:19:29.9133333+00:00
Victor Corral 0 Reputation points
commented 2024-12-10T02:13:37.4366667+00:00
Chandra Boorla 8,470 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.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,331 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,258 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,313 questions
asked 2024-12-03T10:34:09.55+00:00
T, Charandeep 0 Reputation points
commented 2024-12-09T18:08:25.61+00:00
phemanth 13,800 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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,377 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,331 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,258 questions
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 20,295 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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
asked 2024-10-22T08:36:48.19+00:00
Isuke Motoo 0 Reputation points
edited the question 2024-12-04T11:20:54.6+00:00
Rakesh Gurram 12,200 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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
asked 2024-11-14T10:00:35.4933333+00:00
Quyen Dang 21 Reputation points
commented 2024-11-29T17:00:07.5566667+00:00
phemanth 13,800 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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
3,088 questions
asked 2024-11-21T16:49:54.0966667+00:00
Rui Domingos (JTA Consulting S A) 0 Reputation points Microsoft Vendor
commented 2024-11-28T10:05:47.68+00:00
Chandra Boorla 8,470 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…

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,477 questions
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
asked 2024-11-12T18:02:09.4366667+00:00
Ludwig Wurmannstätter 20 Reputation points
commented 2024-11-19T09:48:21.72+00:00
Ludwig Wurmannstätter 20 Reputation points