SQL Server Analysis Services

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…

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…

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…

"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 ?

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…

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?

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…

Unable to install SQL server

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. …

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…

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…

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…

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…

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…

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 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…

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…

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:…

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…

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…