1,290 questions with SQL Server Analysis Services tags

Sort by: Updated
Updated Created Answers
0 answers

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,290 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.
226 questions
asked 2024-11-01T00:37:59.1866667+00:00
Eric Ziola 21 Reputation points
0 answers

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

I am unable to successfully install the Microsoft.DataTools.AnalysisServices.vsix Visual Studio 2022 extension on my new Lenovo CoPilot+PC ARM64 Snapdragon computer. Are there any workarounds that would allow me to develop Analysis Services models in…

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,290 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.
226 questions
asked 2024-11-01T00:31:46.2566667+00:00
Eric Ziola 21 Reputation points
0 answers

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,290 questions
asked 2024-10-29T14:04:51.6566667+00:00
Oleksandr Demianchuk 0 Reputation points
edited the question 2024-10-29T14:10:59.5866667+00:00
Oleksandr Demianchuk 0 Reputation points
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.
456 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.
13,947 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,290 questions
asked 2024-10-22T04:36:30.9633333+00:00
Jamie 0 Reputation points
edited a comment 2024-10-29T08:09:30.23+00:00
phemanth 11,125 Reputation points Microsoft Vendor
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,290 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 37,221 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.
456 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,290 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,290 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.
13,947 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,290 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.
101 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
1 answer

The workspace database server localhost is not found ( SSAS PROJECT)

Good evening everyone :) I Developed an SSAS project through visual studio. Every thing worked fine but today while trying to open the project but I had this error message: "Error in Visual Studio: You cannot open the IBM file. The workspace…

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,290 questions
asked 2023-11-07T17:04:11.56+00:00
khouloud Belhaj 91 Reputation points
commented 2024-10-11T14:44:47.0666667+00:00
Eric Ziola 21 Reputation points
0 answers

OLAP Cube refresh fail on re-opening

Hi all We have an Excel pivot that is connected to an OLAP Cube using msmdpump and basic authentication. When we create the connection it works fine, but as soon as the workbook is saved and re-opened, we are unable to interact with the pivot or…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,947 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,290 questions
asked 2024-10-09T07:56:42.2433333+00:00
Zelda Borchardt 0 Reputation points
1 answer

Date Fields Appearing as Text and Not Grouping Properly in Excel Filters (SSAS Tabular Model)

We are experiencing an issue with our SSAS Tabular model where fields defined as "Date" are being recognized as "Text" when connected to via Excel. This behavior impacts the ability to use Excel's date functionalities, such as…

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,290 questions
asked 2024-10-07T16:58:30.5533333+00:00
in.prc 5 Reputation points
edited an answer 2024-10-08T07:45:21.1533333+00:00
MikeyQiaoMSFT-0444 3,190 Reputation points
0 answers

Analysis Service very slow to connect in SQL Management Studio

Hi all, I have a SQL Server, SSAS and SQL Server Management Studio installed on the same PC. Connecting to the SQL Database Engine in SSMS is very fast. However, connecting to SSAS in SSMS is excruciatingly slow, even though it is just a localhost…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,947 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,290 questions
asked 2024-06-25T04:30:15.7066667+00:00
Norman K. F. Chow 80 Reputation points
commented 2024-10-07T07:30:11.5033333+00:00
Norman K. F. Chow 80 Reputation points
2 answers

I have installed Microsoft SQL Server 2022, but I cannot see the SSIS & SSAS packages.

Good day! When I installed SQL Server, I remember having ticked the options that asked me whether I wanted to include SSAS, SSIS & SSRS; I ticked them all since I wanted to have a many features as I possibly could. Now, am studying the book below: I…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,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.
13,947 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,934 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,587 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,290 questions
asked 2024-09-30T10:23:41.08+00:00
Eric KALONJI 0 Reputation points
commented 2024-09-30T13:48:32.31+00:00
Eric KALONJI 0 Reputation points
2 answers

Prevent access from excel

I am looking to prevent access from Excel to my SSAS... I have 10 cubes, and several PowerBI that consume from it... But I have some users that connect from excel and I want to prohibit that access. How can I prevent people accessing from excel?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,947 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,290 questions
asked 2024-09-18T13:04:27.5766667+00:00
mm 0 Reputation points
commented 2024-09-30T08:45:39.3233333+00:00
MikeyQiaoMSFT-0444 3,190 Reputation points
3 answers

SQL Server agent job that processes SSAS database gets warning 1092091904

Message Executed as user: xxxxxx. <return xmlns="urn:schemas-microsoft-com:xml-analysis"><root xmlns="urn:schemas-microsoft-com:xml-analysis:empty"><Messages…

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,290 questions
asked 2020-08-18T15:52:04.263+00:00
appsac 1 Reputation point
answered 2024-09-26T10:18:44.0366667+00:00
Silviu Vladutu BCR 0 Reputation points
1 answer

Testing migration of SQL/SSAS from 2017 to 2019, when editing an SSAS database connection in SSMS 18.12.1 results in an error - Object reference not set to an instance of an object. (Microsoft.AnalysisServices.SsmsManagementDialogs)

After updating connection string properties, SSMS returns TITLE: Microsoft SQL Server Management Studio ------------------------------ Object reference not set to an instance of an object. (Microsoft.AnalysisServices.SsmsManagementDialogs) …

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.
536 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,290 questions
asked 2022-07-13T15:04:26.47+00:00
Spencer-Jones, Mike 6 Reputation points
commented 2024-09-26T10:16:56.4066667+00:00
Silviu Vladutu BCR 0 Reputation points
1 answer

Deselecting Members In An Excel PivotTable Leads To Missing Rows version 2

Dear community, I followed the steps from this guide…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,947 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,290 questions
asked 2024-09-23T14:04:55.0333333+00:00
Philip Østergaard Braun 0 Reputation points
commented 2024-09-25T12:53:53.2+00:00
Philip Østergaard Braun 0 Reputation points
1 answer One of the answers was accepted by the question author.

Processing monthly Partition from SQL Job using Stored Procedure

Hello Expert, I have a Tabular model which is having a fact table partitioned monthly on date field. e,g. Partition_July2024, Partition_Aug_2024, Partiton_Sept2024 etc.. I want to create a single SQL job to process these monthly partitions which should…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,947 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,290 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,650 questions
asked 2024-09-23T06:43:51.1533333+00:00
PANDEY Prashant 145 Reputation points
commented 2024-09-24T11:17:01.93+00:00
PANDEY Prashant 145 Reputation points
2 answers One of the answers was accepted by the question author.

how to get max min date from a tuple

suppose i have a bunch of people (with dimension) they have a bunch of claims (dimension) and in each claim there is a bunch of records with amount and date! those records/transactions form a cube with measures like amounts paid Ultimately i need to get…

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,290 questions
asked 2024-09-19T10:53:17.7133333+00:00
greg lipman 81 Reputation points
commented 2024-09-23T13:16:14.75+00:00
greg lipman 81 Reputation points
2 answers

PivotTable in Excel

Hi All, I'm using a tabular model in Excel, everytime i add a filter, row or column in the PivotTable, the excel tries to execute the query to refresh data. Since our tabular model is full of data and dax, it takes time every time the excel refresh…

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,290 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,725 questions
asked 2021-05-03T21:26:19.957+00:00
Samir abdelmalek 21 Reputation points
edited a comment 2024-09-19T02:30:33.8966667+00:00
MyName-0111 0 Reputation points