1,300 questions with SQL Server Analysis Services tags

Sort by: Updated
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.
465 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,300 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 33,976 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Unable to Send Emails from SQL Server

There is an issue with sending emails from SQL Server, accompanied by the following error message: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2024-12-03T11:05:46). Exception Message:…

SQL Server on Azure Virtual Machines
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,213 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,617 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,300 questions
asked 2024-12-23T08:38:01.5766667+00:00
Avinash 20 Reputation points
commented 2024-12-23T11:44:18.4133333+00:00
Naveen Kumar M 75 Reputation points
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.
465 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,047 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,300 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 5,755 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.
465 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,213 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,300 questions
asked 2024-10-22T04:36:30.9633333+00:00
Jamie 0 Reputation points
commented 2024-12-10T15:42:58.3333333+00:00
phemanth 12,575 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.
465 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,284 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,047 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,300 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 12,575 Reputation points Microsoft Vendor
1 answer

Visual Studio 2017 Analysis services - parallel processing

We use Visual studio Professional 2017 to develop an Analysis Services Processing task to process Tabular Cube. We are trying to change the processing to Parallel, when we save the change and open processing options again the changes applied are back to…

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,300 questions
asked 2024-11-29T12:29:37.29+00:00
Asam Khan (ASK) 0 Reputation points
answered 2024-12-08T00:21:45.99+00:00
Greg Low 1,930 Reputation points Microsoft Regional Director
1 answer One of the answers was accepted by the question author.

Join two unrelated tables and return only the first row instance for data repeated in a column

I am attempting to join two unrelated tables and return only one row instance for repeating data in a column. TABLE A TABLE B DESIRED RESULT EVALUATE VAR A = DISTINCT ( CALCULATETABLE ( SELECTCOLUMNS ( …

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,300 questions
asked 2024-12-04T14:59:36.94+00:00
Adrian Martinez II 25 Reputation points
accepted 2024-12-05T14:32:13.08+00:00
Adrian Martinez II 25 Reputation points
0 answers

While connecting PowerBi Dataset from SSIS through SSAS processing Task

While connecting PowerBi Dataset from SSIS through SSAS processing Task , I could not make test connection successful. However, I could the tables of PBI dataset and while processing it is throwing the error like below "[Analysis Services…

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,213 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,617 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,300 questions
asked 2024-12-02T08:26:30.1966667+00:00
Prabu, Chandran 41 Reputation points
commented 2024-12-03T07:26:35.6733333+00:00
ZoeHui-MSFT 38,951 Reputation points
4 answers One of the answers was accepted by the question author.

how to change tabular mode to multidimensional model?

Hi there, I am trying to deploy multidimensional project to sql server and get an error. I was installed a tabular database. How to change tabular to multidimensional? Or I need to reinstall SSAS?

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,300 questions
asked 2021-09-23T02:32:42.227+00:00
ismepopola 76 Reputation points
answered 2024-12-01T01:55:58.1766667+00:00
Paul Garnes 0 Reputation points
0 answers

SSAS Idle Causing High Resource Usage on Azure VM

We’re experiencing significant performance issues on an Azure VM configured with E8s_v5 specs (8 vCPUs, 64GB RAM). When SQL Server Analysis Services (SSAS) is running but idle (no data processing), the VM slows to a near halt, even with minimal SQL…

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
8,172 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,213 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,300 questions
asked 2024-11-26T20:36:03.3133333+00:00
Peter Fellows 0 Reputation points
edited a comment 2024-11-29T08:29:07.94+00:00
Akshay kumar Mandha 1,575 Reputation points Microsoft Vendor
1 answer

Why the same issue is been addressing in both KB

KB5042749: This KB article addresses the CVE-2024-37341 vulnerability by fixing a specific issue in the affected software. The exact nature of the fix can include code changes to eliminate the vulnerability, such as patching a security hole or updating…

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,213 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,300 questions
asked 2024-11-21T06:28:55.12+00:00
Balakrishna 0 Reputation points Microsoft Vendor
commented 2024-11-26T11:44:47.03+00:00
Balakrishna 0 Reputation points Microsoft Vendor
1 answer

Microsoft.AnalysisServices 19.86.2.1 is not adapted to work on Linux.

Hi, When I try to connect to Server from Microsoft.AnalysisServices.Tabular on my local machine which is on Windows, it works correctly. While in Kubernetes cluster I get the error The type initializer for…

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,300 questions
asked 2024-10-29T14:04:51.6566667+00:00
Oleksandr Demianchuk 0 Reputation points
answered 2024-11-12T11:36:24.12+00:00
Oleksandr Demianchuk 0 Reputation points
4 answers One of the answers was accepted by the question author.

i get an error when connecting sql server using SSMS .

Cannot connect to PANKAJ\SQLEXPRESS. =================================== A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued…

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,213 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,300 questions
asked 2023-03-01T10:47:14.23+00:00
pankaj prajapati 20 Reputation points
commented 2024-11-11T10:32:16.96+00:00
JP 0 Reputation points
1 answer

SSAS: Unable to view database| http://localhost/mis/tmis/msmdpump.dll

Hello, We have MSSQL2016 Enterprises Edition. When we connect to Analysis Server Instance "hostname\instancename" we can see databases. When we enter [http://localhost/mis/tmis/msmdpump.dll] we connect to Analysis Server Instance but cannot be…

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,300 questions
asked 2024-11-11T07:37:22.4366667+00:00
Nikhil Desai 21 Reputation points
answered 2024-11-11T09:05:44.4533333+00:00
ZoeHui-MSFT 38,951 Reputation points
1 answer

Unable to install sql server 2022 express on my Personal laptop. Could you please help with it? Iam struggling here. Any amount of help is appreciated

The following is the message i see in my log file Overall summary: Final result: Failed: see details below Exit code (Decimal): -2147467259 Start time: 2024-10-31 14:13:52 End time: …

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,213 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,960 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,617 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,300 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,670 questions
asked 2024-10-31T19:40:38+00:00
Harshini Reddy Bobbala 0 Reputation points
answered 2024-11-04T01:39:52.6033333+00:00
ZoeHui-MSFT 38,951 Reputation points
2 answers One of the answers was accepted by the question author.

Visual Studio 2022 Analysis Services Extension on Windows 11 ARM64 (Lenovo Snapdragon)

I recently purchased a Lenovo CoPilot+PC ARM64 Snapdragon Windows 11 computer. I keep getting an error when I try to install the Analysis Services Extension for Visual Studio 2022 (Microsoft.DataTools.AnalysisServices.vsix). Is there a workaround to be…

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,300 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
235 questions
asked 2024-11-01T00:37:59.1866667+00:00
Eric Ziola 41 Reputation points
commented 2024-11-01T15:07:30.0433333+00:00
Eric Ziola 41 Reputation points
1 answer

PDF Extract dispalying complete information.

Hi Everyone, Can anyone guide me in extracting the power bi report / table visual data into pdf format . Am trying to extract using power automate, but the information are hidden. Is there any workaround to extract to pdf with full information.

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,300 questions
asked 2024-10-23T09:11:10.8333333+00:00
N, Rubini 0 Reputation points
answered 2024-10-25T06:58:36.28+00:00
ZoeHui-MSFT 38,951 Reputation points
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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
465 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,300 questions
asked 2023-08-28T17:32:41.98+00:00
Cperer 21 Reputation points
commented 2024-10-18T14:39:12.8266667+00:00
Mattias Kuosku 0 Reputation points
0 answers

SSAS connections are not happening through msmdpump.dll while doing the load tests. What to do?

Hi All, We are performing a 1 hour load test of 300 users and 370 users on SSAS and we are seeing that application is working fine under 300 user load. However, when we are conducting 370 users test, in the first 20 minutes CPU was getting occupied 100%…

Internet Information Services
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,300 questions
asked 2024-10-16T07:20:28.5433333+00:00
sathish hanumandla 0 Reputation points
commented 2024-10-16T07:26:03.42+00:00
sathish hanumandla 0 Reputation points
1 answer One of the answers was accepted by the question author.

Runing SSAS Tabular Processing Script (TMSL) from SSAS Database Engine

Hello Experts, In continuation of my previous question https://learn.microsoft.com/en-us/answers/questions/2076521/processing-monthly-partition-from-sql-job-using-st?source=docs We have SSAS Tabular model database and SSAS Database engine. When trying to…

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,213 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,300 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
108 questions
asked 2024-09-24T11:15:03.1866667+00:00
PANDEY Prashant 145 Reputation points
accepted 2024-10-14T06:50:21.2266667+00:00
PANDEY Prashant 145 Reputation points