1,343 questions with SQL Server Analysis Services tags

Sort by: Updated
2 answers

How to Get SQL Logs (UPDATE, INSERT and DELETE)of Specific Table from SQL Server if Query run from Website.

Hi, How to Get SQL Logs (UPDATE, INSERT and DELETE)of Specific Table from SQL Server if Query run from Website. Please Help

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,492 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.
3,056 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,343 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,707 questions
asked 2022-03-17T05:24:08.337+00:00
Faizan Ahmed 1 Reputation point
commented 2025-06-12T11:57:38.4266667+00:00
Ilya 0 Reputation points
4 answers

Best Practice to Decide Partition Table in SQL Server

Hi All, We have a database on SQL server with a large size (about 20 TB) and we plan to partition the existing tables in the database. but we are still confused to determine whether to partition the table, whether it should be partitioned…

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,492 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,343 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,707 questions
asked 2022-10-13T03:39:13.957+00:00
Arief Hardiansyah 51 Reputation points
commented 2025-06-04T20:30:39.26+00:00
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
0 answers

Incorrect final summation in tabular model

Good day. I encountered a problem with incorrect aggregation. There is a dimension in the system with a hierarchy built in it. During aggregation, incorrect summation of data for hierarchy members occurs. At the same time, with each processing on the…

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,343 questions
asked 2025-06-03T14:12:59.0933333+00:00
Acid Aquamarine 0 Reputation points
edited the question 2025-06-03T14:14:09.07+00:00
Acid Aquamarine 0 Reputation points
2 answers

Azure Synapse "Message Type Not Found" error when running stored procedure: Appears when lines of code reach certain line length

Hi, We need some technical guidance from either a Azure Synapse specialist to resolve an issue which we are unable to understand / fix despite running through the sql logic bit-by-bit, line-by-line. Any guidance or help would be much appreciated. We have…

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,359 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,343 questions
asked 2024-07-22T17:24:40.0233333+00:00
Michael King 0 Reputation points
answered 2025-06-02T12:56:46.32+00:00
Carter Hughes 0 Reputation points
1 answer

Best Way to Sync/Mirror a Database Without Primary Keys to Azure Analytics (Fabric, Synapse, Databricks)?

I’m exploring solutions to sync/mirror an external database (SQL Server/Azure SQL DB) to Azure analytics services (Microsoft Fabric, Synapse, Databricks), but my source tables do not have primary keys (PKs). Current Challenges: Explored Synapse sync…

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,343 questions
asked 2025-05-30T12:58:06.2866667+00:00
Gnanasoundari 45 Reputation points
commented 2025-05-31T08:09:31.0733333+00:00
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
1 answer

How to create ISAPI Filter in visual studio 2012 onwards

Hi Team, We are using MSMD Pump for our analysis services. where, it is hosted on IIS and shared URL to users those are accessing our cubes without having explicit access on our cube server. But now we have a requirement to track all the request…

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,343 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
1,044 questions
asked 2020-10-07T15:34:21.47+00:00
Mukesh Dutt 1 Reputation point
edited the question 2025-05-29T21:44:35.51+00:00
DillanSimmons 6 Reputation points Admin
4 answers

IDbConnection error on process SASS database caused by Windows updates

Hello, At some point, our developer instance of Analysis Services started to give an error: Errors in the high-level relational engine. . The exception was raised by the IDbConnection interface. It does not contain any on what is wrong with it. It…

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,343 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
1,044 questions
asked 2020-09-22T10:05:03.96+00:00
Vladimir Kovalenko 11 Reputation points
edited the question 2025-05-29T21:41:06.4766667+00:00
DillanSimmons 6 Reputation points Admin
1 answer One of the answers was accepted by the question author.

Discrepancy Between Installer name and Product Version of Microsoft Analysis Services OLE DB Provider

Hi Team, We are 3rd party patch provider like PatchMyPC or ManageEngine where we are providing the metadata on how to deploy the application silently. Please refer - https://adaptiva.com/products/onesite-patch We recently accessed the latest download…

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,343 questions
asked 2025-01-09T04:49:19.9733333+00:00
Simran Kaur 20 Reputation points
edited the question 2025-05-29T16:00:20.54+00:00
Simran Kaur 20 Reputation points
1 answer

Does SQL Server 2012 Standard Edition support Server Level Auditing

Does SQL Server 2012 Standard Edition support Server Level Auditing

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,343 questions
asked 2025-05-28T11:03:47.08+00:00
Rathish S 40 Reputation points
answered 2025-05-28T14:17:50.8433333+00:00
Adharsh Santhanam 6,010 Reputation points Volunteer Moderator
1 answer

Error 1067 when trying to run SQL server

When trying to run SQL server I get Error 1067: The process terminated unexpectedly. Event viewer is showing Event ID 9012 saying "There have been 256 misaligned log IOs which required falling back to synchronous IO. The current IO is on C:"…

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,343 questions
asked 2025-05-22T14:37:11.27+00:00
Eric Shaske 0 Reputation points
commented 2025-05-23T14:59:21.7466667+00:00
Eric Shaske 0 Reputation points
4 answers

SQL Server Analysis server services not starting

Consultants have deployed an SQL Server upgrade but they are pushing back on me because two services won't start (Error 5 - Access Denied). I am not experienced much in SQL and not at all in Analysis Services so I don't know what changes can…

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,492 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,343 questions
asked 2022-04-11T07:41:41.613+00:00
Tim Gowen 21 Reputation points
edited a comment 2025-05-06T20:31:50.31+00:00
Dhirendra Sharma 0 Reputation points
5 answers One of the answers was accepted by the question author.

Analysis Services Processing Task: Error A connection cannot be made

Hi, We are executing an SSIS package.. it fails with the below error Analysis Services Processing Task: Error A connection cannot be made. Ensure that the server is running. We have a separate SSAS instance on this server which is up and running.…

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,343 questions
asked 2024-09-03T04:30:09.63+00:00
Bilal H. Bhatt 136 Reputation points
commented 2025-05-02T21:54:39.98+00:00
Gary Melhaff - US 6 Reputation points
1 answer

Problem upgrading encryption for multidimensional analysis services database in SQL 2022

I am migrating 2 analysis services databases that are in multidimensional mode from a 2017 instance to a 2022 instance that has had the CU1 update applied. I need to upgrade the encryption on these DBs so i can amend the connection string. This article…

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,492 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,343 questions
asked 2023-08-09T11:11:35.6666667+00:00
Jim Dale 15 Reputation points
commented 2025-05-02T16:09:13.2066667+00:00
Céline Rodríguez 16 Reputation points
1 answer One of the answers was accepted by the question author.

use the SAS tokens to read files stored in a container?

Hi, I'm trying to figure out how to use the SAS tokens to read files stored in a container. Could someone guide me on the correct way to use these tokens?

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,343 questions
asked 2025-04-28T18:05:40.49+00:00
sasthha 40 Reputation points
accepted 2025-04-28T20:54:16.34+00:00
sasthha 40 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,343 questions
asked 2021-09-23T02:32:42.227+00:00
ismepopola 76 Reputation points
commented 2025-04-24T13:08:11.2833333+00:00
Michael Bartlett 0 Reputation points
0 answers

Azure SQL Database Data IO Usage frequently spiking to 100% and staying there unpredictably

Our database is having an issue with DTU percentage spiking to 100% during bursts of high traffic to our webapp. There is a stored procedure that runs on almost every page on our site that we are aware needs to be optimized, and we have taken some steps…

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,343 questions
asked 2025-04-21T19:57:23.84+00:00
Jason Blake 36 Reputation points
0 answers

The server is currently in 'restarting' state. Please wait for the operation to complete. You can refresh to check status. Reach out to Microsoft support if the operation is taking too long.

My Wordpress website was down due to "Error establishing a database connection" I then went forward to "restart" my Azure Database for MySQL flexible server and this process has been going forever and I don't know what to do... this…

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,343 questions
asked 2025-04-11T22:55:19.5633333+00:00
Joana Ribau Leite 0 Reputation points
1 answer

How to install an SQL server app

I just bought an HP computer with Windows 11. I am trying to install an SQL server app.Takes forever to "configure" the services. Could anyone help, please? Thank you

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,343 questions
asked 2025-04-11T13:28:04.8666667+00:00
HM 0 Reputation points
answered 2025-04-11T20:05:26.6766667+00:00
Bruce (SqlWork.com) 77,631 Reputation points Volunteer Moderator
0 answers

Unable to find MicrosoftML R package for ML Services on Sql Server 2022

Hello, I am trying to upgrade my database to Sql Server 2022 from Sql Server 2017. My database uses ML services, including both RevoScaleR and MicrosoftML R packages. I followed the installation steps for ML Services for Sql Server 2022 from here:…

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,343 questions
asked 2025-04-10T19:58:43.7733333+00:00
Nick Yaculak 0 Reputation points
0 answers

unable see data in external created based on tab delimited file

I am able to query an external table made of tab delimited file via spark engine but unable to see any data when queried from SSMS Error faced in sql: Started executing query at Line 1 Warning: No datasets were found that match the expression…

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,343 questions
asked 2025-04-10T18:15:58.7233333+00:00
79571025 0 Reputation points