1,303 questions with SQL Server Analysis Services tags

Sort by: Updated
Updated Created Answers
0 answers

Ensure that the server is running Period Analysis Services Processing

Hello, I have am getting below error while running a job.. I am able to connect the SSAS server with the jobowner, Source: Period Analysis Services Processing Task Description: A connection cannot be made. Ensure that the server is running. End…

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,303 questions
asked 2025-01-08T06:50:56.34+00:00
Bilal H. Bhatt 116 Reputation points
2 answers

Can we enclose column name with double quotes in queries like select query

Hey Team, I'm dealing with multiple teams applications sql server database every day. I'm getting different types and combinations of column names with space, special characters etc. So that's why my query uses square brackets to enclose column names as…

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,257 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,303 questions
asked 2025-01-06T12:18:11.1333333+00:00
Pavan G 0 Reputation points
commented 2025-01-07T02:02:46.3733333+00:00
LiHongMSFT-4306 29,666 Reputation points
2 answers

SQL server analysis cube deployment error

I have a deployment error in visual studio trying to deploy a cube to SQL analysis server. I ensured in the cube solution explorer properties that the server name matches the sql analysis server name and it is running as I can see in SQL configuration…

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,303 questions
asked 2024-12-30T11:15:07.2+00:00
Waddah Alhajar 0 Reputation points
answered 2024-12-31T09:23:31.13+00:00
Waddah Alhajar 0 Reputation points
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,303 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,981 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,257 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 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,303 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,065 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,303 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 6,130 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,257 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,303 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,740 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,297 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,088 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,303 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,740 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,303 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,303 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,257 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 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,303 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 39,271 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,303 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,205 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,257 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,303 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,880 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,257 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,303 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,303 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,257 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,303 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,303 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 39,271 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,257 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,965 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 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,303 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,672 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 39,271 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,303 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.
238 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,303 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 39,271 Reputation points