1,242 questions with SQL Server Analysis Services tags

Sort by: Updated
Updated Created Answers
1 answer

EnableCrossDatabaseFolding for SSAS?

Is there any chance this option will be added also to SSAS? I'd like to no longer have to define views just to fake using only one database.

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,242 questions
asked 2024-03-28T14:46:08.6566667+00:00
Salvatore Iamundo 0 Reputation points
answered 2024-04-18T01:07:40.1733333+00:00
Greg Low 1,155 Reputation points Microsoft Regional Director
0 answers

ODBC Connection Error- SSMS

We are getting ODBC/Connection Error for few of the jobs which are running in SSAS. while some other jobs are running fine with the same ODBC Connection. Error: Message Executed as user: NA\ps498921. Microsoft.AnalysisServices.Xmla.XmlaException: 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,242 questions
asked 2024-03-05T05:40:44.61+00:00
KANCHI BIANCA (CRGL-THIRDPARTY.COM) 5 Reputation points
commented 2024-04-15T15:28:20.3+00:00
MANJUNATH RAMAMURTHY 0 Reputation points
1 answer

Urgent question when i install SQL Server display error Could not find the Database Engine startup handle.

solve this please

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,638 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,790 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,450 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,242 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
4 questions
asked 2024-04-14T11:17:03.4666667+00:00
hamada mostafa mohammed othman 0 Reputation points
edited a comment 2024-04-15T02:46:22.8066667+00:00
LucyChen-MSFT 480 Reputation points Microsoft Vendor
3 answers

SSAS : How to avoid 2 Billion distinct values in a Column limit

Hello All, We have our tabular models with 25+ Billions of records with aggregated fact tables. Recently when we processed our one of fact table, we got the error on a whole number data type column as Error: The 'column' of the 'table'…

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,242 questions
asked 2021-03-04T13:30:26.987+00:00
MohanV 1 Reputation point
commented 2024-04-10T18:30:08.2233333+00:00
Selvaraju, Lourdes Alex Clement 0 Reputation points
1 answer

SSAS Tabular model 2022 (Disappear specific data import feature)

Hi All, I am unable to find the below feature in SSAS 2022 version, does anyone know how to import specific data into SSAS 2022. The screen below appears when importing data from an existing connection in SSAS 2022. Thanks in advance.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
436 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,242 questions
asked 2024-04-03T07:21:55.98+00:00
Manikant Mahovia 41 Reputation points
commented 2024-04-04T08:07:41.6966667+00:00
PRADEEPCHEEKATLA-MSFT 76,511 Reputation points Microsoft Employee
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.
12,638 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,242 questions
asked 2023-03-01T10:47:14.23+00:00
pankaj prajapati 20 Reputation points
commented 2024-04-03T18:16:08.02+00:00
Precious Bereiweriso 0 Reputation points
3 answers

has inline function got any catch?

hi, I heard many people saying "functions are denounced in tsql" is there any catch? q1) need to know what are the cases where we should not use? q2) should we avoid scaler functions also? q3) should we avoid scaler functions if we have 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.
12,638 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,790 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,450 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,242 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,547 questions
asked 2024-03-11T05:57:35.8533333+00:00
Rajesh Kumar Yadav 0 Reputation points
answered 2024-03-26T17:11:52.99+00:00
Bruce (SqlWork.com) 54,866 Reputation points
3 answers

unable to uninstall sql server 2019

while uninstalling sql server the below error is popping up kindly 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.
12,638 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
490 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,242 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,096 questions
asked 2023-01-22T06:48:48.7666667+00:00
Madhusudhan 0 Reputation points
commented 2024-03-26T14:06:35.2366667+00:00
Leo R 0 Reputation points
3 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,242 questions
asked 2021-09-23T02:32:42.227+00:00
ismepopola 71 Reputation points
commented 2024-03-18T11:48:18.1433333+00:00
Nemanja Mijajlović 0 Reputation points
1 answer

Why can't I connect to analysis services from ssms?

I am getting the below error. Is there something I am missing? Unable to obtain authentication token using the credentials provided. (Microsoft.AnalysisServices.AdomdClient) There was an error parsing WS-Trust response from the endpoint. This may occur…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
436 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,242 questions
asked 2024-03-05T20:42:07.4366667+00:00
Adam Garcia 0 Reputation points
answered 2024-03-05T23:02:34.99+00:00
Greg Low 1,155 Reputation points Microsoft Regional Director
1 answer

timestamp manupulation

Hey, here is the table & it contains timestamp at the end. check the output create table customer (CustomerName char(22), ContactName char(22), Address char(22), City char(22) , PostalCode char(22), Country char(22),time DATETIME DEFAULT…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,638 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,450 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,242 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,547 questions
asked 2024-02-26T04:40:10.3066667+00:00
Vineet S 145 Reputation points
edited the question 2024-03-04T17:56:13.4133333+00:00
Oury Ba-MSFT 16,076 Reputation points Microsoft Employee
1 answer

Can Azure Migrate handle other SQL Server components?

Hello, I have just started to work on a migration project for a client that has the current onpremise environment on Win/SQL 2012 and want to replatform (migrate & upgrade) to Win/SQL 2019. They have cubes (SSAS), Reports (SSRS) and SSIS that need to…

Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
716 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.
12,638 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,790 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,450 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,242 questions
asked 2024-02-26T17:48:38.31+00:00
Abimbola Adeniran 21 Reputation points
commented 2024-03-01T23:20:13.1033333+00:00
Marcin Policht 9,040 Reputation points MVP
1 answer One of the answers was accepted by the question author.

json file in sql server

could you please explain how we can load below curly bracket files in sql server when there are multiple unwanted curly brackets are there apart from main data? in this case data is available in till Result only {     "Generic": {        …

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,638 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,450 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,242 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,547 questions
asked 2024-03-01T02:01:10.4466667+00:00
Vineet S 145 Reputation points
edited an answer 2024-03-01T03:09:35.2533333+00:00
Yitzhak Khabinsky 24,936 Reputation points
2 answers

Azure Analysis Server becomes unresponsive if tables are getting processed

We have multiple Power BI reports hosted on a server(S9V2) which has multiple databases. We have been noticing that whenever entities are getting processed, the reports are becoming very slow and even the processing of entities take more time than…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
436 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,242 questions
asked 2024-02-26T17:23:14.1466667+00:00
Sachin Kumar 1 Reputation point Microsoft Employee
answered 2024-02-29T06:19:04.5833333+00:00
Greg Low 1,155 Reputation points Microsoft Regional Director
3 answers

Cannot connect to SQL Management studio 19.3

Hi Microsoft team, I have been trying to connect to the SQL server for a long time now and i have been getting error message cannot connect to.... How can i overcome this challenge?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,638 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,790 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,450 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,242 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.
40 questions
asked 2024-02-08T16:10:07.1266667+00:00
Boluwaji Olusegun 0 Reputation points
commented 2024-02-29T05:56:26.4866667+00:00
CosmogHong-MSFT 22,616 Reputation points Microsoft Vendor
1 answer

Partitioning dataset and Refreshing power BI

Hello, We had a dataset with 5 years data, then reduced the size to only 30 months data to improve performance. Now we want to automate Power BI refresh but getting an error: "This operation was canceled because there wasn't enough memory to finish…

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,242 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,032 questions
asked 2024-02-20T23:05:47.67+00:00
Amir_m 0 Reputation points
commented 2024-02-28T10:52:39.2633333+00:00
Chris Webb 0 Reputation points Microsoft Employee
1 answer

We are using windows 2022 server with SQL 2022, the problem is that after sysprep execute ,sql analysis failed with Error:Failed to encrypt sensitive data. Possibly the encryption key is inaccessible because of improper service account change

After upgrade the image to win22 and sql22. Not able to run bam Analysis service getting error Microsoft.BizTalk.Bam.Management.BamManagerException: The BAM deployment failed. ---> Microsoft.AnalysisServices.OperationException: Errors in the…

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,077 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,450 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,242 questions
asked 2024-02-09T08:23:31.9833333+00:00
Kasireddy Alekhya Alekhya (MINDTREE LIMITED) 0 Reputation points
commented 2024-02-28T05:17:41.5966667+00:00
Kasireddy Alekhya Alekhya (MINDTREE LIMITED) 0 Reputation points
1 answer One of the answers was accepted by the question author.

multiple merge condition

Hey, due to multiple merged condition in same query, it is taking lots of time to run in sql tried partition but did not work . what can be best approach?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,638 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,790 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,450 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,242 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,547 questions
asked 2024-02-27T23:50:13.4333333+00:00
Vineet S 145 Reputation points
accepted 2024-02-28T02:09:44.1233333+00:00
Vineet S 145 Reputation points
1 answer

permissions to refresh a data model in azure analysis services

I am refreshing a data model in Azure Analysis Services using an Azure Function App (C# .NET 6). I am using the Microsoft.AnalysisServices.Tabular package available at https://www.nuget.org/packages/Microsoft.AnalysisServices.NetCore.retail.amd64. When I…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
436 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,211 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,344 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,242 questions
asked 2024-02-19T11:10:09.8366667+00:00
Muhammad Pathan 25 Reputation points
commented 2024-02-26T08:22:59.33+00:00
PRADEEPCHEEKATLA-MSFT 76,511 Reputation points Microsoft Employee
1 answer

windows server 2008 and windows 10 and sql server 2000

I have a network around Windows Server 2008, and client workstations under Windows 7 and SQL Server 2000 database applications, everything works well by adding a workstation under Windows 10 and SQL Server 2000 locally it works well, but in network 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,242 questions
Windows 10 Network
Windows 10 Network
Windows 10: A Microsoft operating system that runs on personal computers and tablets.Network: A group of devices that communicate either wirelessly or via a physical connection.
2,266 questions
asked 2024-02-17T18:17:27.0266667+00:00
alaya mohsen 0 Reputation points
commented 2024-02-19T03:19:42.02+00:00
ZoeHui-MSFT 32,426 Reputation points