Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
465 questions
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…
asked 2024-12-19T01:25:16.54+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 2%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DS87
0
Reputation points
commented 2024-12-24T06:38:19.0966667+00:00
AnnuKumari-MSFT
33,976
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:…
asked 2024-12-23T08:38:01.5766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 8%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Avinash
20
Reputation points
commented 2024-12-23T11:44:18.4133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 60%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
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…
asked 2024-12-18T19:59:10.02+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 97%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETR%3C/text%3E%3C/svg%3E)
Ted Rogers
0
Reputation points
commented 2024-12-23T01:04:11.75+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chandra Boorla
5,755
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 26%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
1 answer
How can I update the data source (Azure Storage) for Azure Analysis Services without using the SQLServer module or the Invoke-ASCmd method, preferably using Python?
I am looking for a way to achieve this using Python. Please suggest any tools, libraries, or approaches that can facilitate this, such as using REST APIs or handling XMLA directly. A step-by-step explanation or references would be greatly appreciated.
asked 2024-12-03T10:34:09.55+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 80%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
T, Charandeep
0
Reputation points
commented 2024-12-09T18:08:25.61+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
phemanth
12,580
Reputation points Microsoft Vendor
1 answer
Visual Studio 2017 Analysis services - parallel processing
We use Visual studio Professional 2017 to develop an Analysis Services Processing task to process Tabular Cube. We are trying to change the processing to Parallel, when we save the change and open processing options again the changes applied are back to…
asked 2024-11-29T12:29:37.29+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 39%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Asam Khan (ASK)
0
Reputation points
answered 2024-12-08T00:21:45.99+00:00
Greg Low
1,930
Reputation points Microsoft Regional Director
1 answer
One of the answers was accepted by the question author.
Join two unrelated tables and return only the first row instance for data repeated in a column
I am attempting to join two unrelated tables and return only one row instance for repeating data in a column. TABLE A TABLE B DESIRED RESULT EVALUATE VAR A = DISTINCT ( CALCULATETABLE ( SELECTCOLUMNS ( …
asked 2024-12-04T14:59:36.94+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 4%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Adrian Martinez II
25
Reputation points
accepted 2024-12-05T14:32:13.08+00:00
Adrian Martinez II
25
Reputation points
0 answers
While connecting PowerBi Dataset from SSIS through SSAS processing Task
While connecting PowerBi Dataset from SSIS through SSAS processing Task , I could not make test connection successful. However, I could the tables of PBI dataset and while processing it is throwing the error like below "[Analysis Services…
asked 2024-12-02T08:26:30.1966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 95%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Prabu, Chandran
41
Reputation points
commented 2024-12-03T07:26:35.6733333+00:00
ZoeHui-MSFT
38,956
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?
asked 2021-09-23T02:32:42.227+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 60%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
ismepopola
76
Reputation points
answered 2024-12-01T01:55:58.1766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 14.000000000000002%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPG%3C/text%3E%3C/svg%3E)
Paul Garnes
0
Reputation points
0 answers
SSAS Idle Causing High Resource Usage on Azure VM
We’re experiencing significant performance issues on an Azure VM configured with E8s_v5 specs (8 vCPUs, 64GB RAM). When SQL Server Analysis Services (SSAS) is running but idle (no data processing), the VM slows to a near halt, even with minimal SQL…
asked 2024-11-26T20:36:03.3133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 8%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPF%3C/text%3E%3C/svg%3E)
Peter Fellows
0
Reputation points
edited a comment 2024-11-29T08:29:07.94+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 86%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Akshay kumar Mandha
1,655
Reputation points Microsoft Vendor
1 answer
Why the same issue is been addressing in both KB
KB5042749: This KB article addresses the CVE-2024-37341 vulnerability by fixing a specific issue in the affected software. The exact nature of the fix can include code changes to eliminate the vulnerability, such as patching a security hole or updating…
asked 2024-11-21T06:28:55.12+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 60%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Balakrishna
0
Reputation points Microsoft Vendor
commented 2024-11-26T11:44:47.03+00:00
Balakrishna
0
Reputation points Microsoft Vendor
1 answer
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…
asked 2024-10-29T14:04:51.6566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 54%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOD%3C/text%3E%3C/svg%3E)
Oleksandr Demianchuk
0
Reputation points
answered 2024-11-12T11:36:24.12+00:00
Oleksandr Demianchuk
0
Reputation points
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…
asked 2023-03-01T10:47:14.23+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 44%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
pankaj prajapati
20
Reputation points
commented 2024-11-11T10:32:16.96+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 95%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JP
0
Reputation points
1 answer
SSAS: Unable to view database| http://localhost/mis/tmis/msmdpump.dll
Hello, We have MSSQL2016 Enterprises Edition. When we connect to Analysis Server Instance "hostname\instancename" we can see databases. When we enter [http://localhost/mis/tmis/msmdpump.dll] we connect to Analysis Server Instance but cannot be…
asked 2024-11-11T07:37:22.4366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 7.000000000000001%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3END%3C/text%3E%3C/svg%3E)
Nikhil Desai
21
Reputation points
answered 2024-11-11T09:05:44.4533333+00:00
ZoeHui-MSFT
38,956
Reputation points
1 answer
Unable to install sql server 2022 express on my Personal laptop. Could you please help with it? Iam struggling here. Any amount of help is appreciated
The following is the message i see in my log file Overall summary: Final result: Failed: see details below Exit code (Decimal): -2147467259 Start time: 2024-10-31 14:13:52 End time: …
asked 2024-10-31T19:40:38+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 86%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHR%3C/text%3E%3C/svg%3E)
Harshini Reddy Bobbala
0
Reputation points
answered 2024-11-04T01:39:52.6033333+00:00
ZoeHui-MSFT
38,956
Reputation points
2 answers
One of the answers was accepted by the question author.
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,300 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.
235 questions
asked 2024-11-01T00:37:59.1866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 51%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEZ%3C/text%3E%3C/svg%3E)
Eric Ziola
41
Reputation points
commented 2024-11-01T15:07:30.0433333+00:00
Eric Ziola
41
Reputation points
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.
asked 2024-10-23T09:11:10.8333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 59%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
N, Rubini
0
Reputation points
answered 2024-10-25T06:58:36.28+00:00
ZoeHui-MSFT
38,956
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…
asked 2023-08-28T17:32:41.98+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 88%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Cperer
21
Reputation points
commented 2024-10-18T14:39:12.8266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 89%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
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%…
asked 2024-10-16T07:20:28.5433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 57.00000000000001%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
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://zcusa.951200.xyz/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…
asked 2024-09-24T11:15:03.1866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 19%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
PANDEY Prashant
145
Reputation points
accepted 2024-10-14T06:50:21.2266667+00:00
PANDEY Prashant
145
Reputation points