1,313 questions with SQL Server Analysis Services tags

Sort by: Updated
0 answers

SSAS Tabular delta schema changes and processing

Hello Experts, We are using AWS hosted SQL and SSAS Tabular both on same instance and the plan is to build environments as Dev & Test Environment: 3 & 6 months respectively, UAT: 1 Year Pre Production: 5 Years Production: 10 Years Our product…

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,313 questions
asked 2025-02-17T07:32:15.36+00:00
PANDEY Prashant 145 Reputation points
edited the question 2025-02-17T08:47:10.2466667+00:00
PANDEY Prashant 145 Reputation points
0 answers

Microsoft SQL Server 2022 Setup error

The following error has occurred: An error occurred while installing extensibility feature with error message: AppContainer Creation Failed with error message CREATING_FIREWALL_RULES, state Could not load file or assembly…

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,485 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,313 questions
asked 2025-02-14T21:39:47.3366667+00:00
D N Sangamesh 0 Reputation points
commented 2025-02-17T06:25:50.2966667+00:00
ZoeHui-MSFT 40,661 Reputation points
2 answers

SSAS Development How to fix "Cannot open BIM Model. Localhost server unreachable" ?

Hello everyone ! I've had a weird problem during the last couple of days. I downloaded a SSAS project from Azure to work on it with some people. I set it up to use "Integrated workspace", and I left everything else as default. The first time I…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 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,313 questions
asked 2025-02-04T10:14:50.5333333+00:00
D2d3d4d5 20 Reputation points
commented 2025-02-14T16:24:07.1266667+00:00
Smaran Thoomu 20,295 Reputation points Microsoft Vendor
2 answers

"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."

One of the users receive this error. is this issue at our end or at microsofts ?

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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,313 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,759 questions
asked 2023-10-25T20:03:28.8633333+00:00
zubaid ahmed 5 Reputation points
commented 2025-02-14T15:11:44.54+00:00
Richard Price 0 Reputation points
1 answer

Build SSAS Tabular Daliy Partition from SQL Server

Hello Experts, We are using SQL Server and SSAS Services, have to automate the process of building daily partition on fact table (TMSL code mentioned below). this should be called from Stored Procedure. I have to code such a way to build daily partitions…

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,485 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,313 questions
asked 2025-02-11T07:24:18.6333333+00:00
PANDEY Prashant 145 Reputation points
answered 2025-02-11T18:34:39.4966667+00:00
Jonathan Pereira Castillo 14,230 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

SSAS Hidden "Unknown Member" But Still Show On Power BI

Hi Expert It's setting Unknown Member "Hidden" for every dimensions on SSAS, and it's display normal on excel 2016 above, but on the Power BI still show "Unknown" in dimensions. Can anyone who will solve 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,313 questions
asked 2025-01-15T09:13:45.1266667+00:00
LRC1006 40 Reputation points
accepted 2025-02-11T01:28:59.54+00:00
LRC1006 40 Reputation points
2 answers

Can only select both tables filter direction in SSAS tabular

Hi, I use the same SQL server database to do an import in Power BI Desktop as for my model created in SSAS Tabular SQL Server 2019 with Visual Studio 2019. My issue is in the create relationships. In Power BI Desktop I can do: In Visual Studio I…

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,313 questions
asked 2023-05-16T14:16:56.12+00:00
Arjan Fraaij 0 Reputation points
commented 2025-02-04T16:32:03.5333333+00:00
Alex Martin 0 Reputation points
3 answers

Unable to install SQL server

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,485 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,996 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,645 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.
547 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,313 questions
asked 2024-06-03T08:19:20.6533333+00:00
Cydrx Malla 5 Reputation points
commented 2025-02-02T00:33:11.85+00:00
Malla, Cydrx Ian 0 Reputation points
1 answer

Execute XMLA on a Unix server

Hello, I would like to know what the best option is to trigger a SSAS cube refresh from an Unix server.   Today I am using powershell on windows with the powershell command line: Invoke-ASCmd -Server myserver:port -InputFile my_refresh_instruction.xmla. …

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,313 questions
asked 2025-01-29T18:47:19.24+00:00
MARIE-MAGDELAINE Dimitri 0 Reputation points
answered 2025-01-30T09:32:46.96+00:00
Olaf Helper 46,031 Reputation points
1 answer

AWS Linked Sever from SQL to SSAS Tabular Model

Hello Experts, We are using SQL Server enterprise edition where both SQL and SSAS(Tabular) are deployed on same RDS. I have to make Linked Server from SQL to SSAS Tabular database so that TMSL data processing/partitions query can be called from stored…

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,485 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,313 questions
asked 2025-01-27T06:00:36.1366667+00:00
PANDEY Prashant 145 Reputation points
answered 2025-01-27T22:31:09.59+00:00
Erland Sommarskog 117.2K Reputation points MVP
0 answers

VS 2012 Tabular : adventure-works-tabular-model-project-1200.zip (Model.bim) can't open in VS 2012

Hi All I have SQL Server 2019 (1500 compatibilty level) I installed VS community edition Version 17.12.3 (with latest SSAS extension) I installed AdventureWorksDW2019 DB and SSAS tabular. First of all I want to install example of SSAS project based on…

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,313 questions
asked 2025-01-16T13:56:03.7933333+00:00
Fiodar Hulin 21 Reputation points
commented 2025-01-23T11:06:00.2466667+00:00
Fiodar Hulin 21 Reputation points
0 answers

SSAS Tabular - How to create Daily Partition on Fact and execute from Stored Procedure

Hello Experts, We have DWH & Tabular database having numbers of Dim and 2 Fact tables. One of the fact table session_member expect 1 millions of data processing per day. Earlier we had no Partitions on Fact tables of Datawarehouse and monthly…

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,313 questions
asked 2025-01-15T06:18:26.0133333+00:00
PANDEY Prashant 145 Reputation points
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/autonomous-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,313 questions
asked 2025-01-09T04:49:19.9733333+00:00
Simran Kaur 20 Reputation points
accepted 2025-01-09T06:19:26.7133333+00:00
Simran Kaur 20 Reputation points
1 answer

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,313 questions
asked 2025-01-08T06:50:56.34+00:00
Bilal H. Bhatt 136 Reputation points
answered 2025-01-09T01:26:26.1866667+00:00
ZoeHui-MSFT 40,661 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,485 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,313 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 30,751 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,313 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.
474 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,313 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 34,011 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,485 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,645 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,313 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.
474 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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,313 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 8,470 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.
474 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,485 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,313 questions
asked 2024-10-22T04:36:30.9633333+00:00
Jamie 0 Reputation points
commented 2024-12-10T15:42:58.3333333+00:00
phemanth 13,800 Reputation points Microsoft Vendor