Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
472 questions
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…
![](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(192, 74%, 28%)' 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)
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…
asked 2023-05-16T14:16:56.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(198.4, 84%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Arjan Fraaij
0
Reputation points
commented 2025-02-04T16:32:03.5333333+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, 35%, 18%)' 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)
Alex Martin
0
Reputation points
3 answers
asked 2024-06-03T08:19:20.6533333+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(57.599999999999994, 46%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Cydrx Malla
5
Reputation points
commented 2025-02-02T00:33:11.85+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(73.60000000000001, 50%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
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. …
asked 2025-01-29T18:47:19.24+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(236.8, 94%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
MARIE-MAGDELAINE Dimitri
0
Reputation points
answered 2025-01-30T09:32:46.96+00:00
Olaf Helper
45,881
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…
asked 2025-01-27T06:00:36.1366667+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
answered 2025-01-27T22:31:09.59+00:00
Erland Sommarskog
116.5K
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…
asked 2025-01-16T13:56:03.7933333+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(163.2, 3%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFH%3C/text%3E%3C/svg%3E)
Fiodar Hulin
21
Reputation points
commented 2025-01-23T11:06:00.2466667+00:00
Fiodar Hulin
21
Reputation points
1 answer
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?
asked 2025-01-15T09:13:45.1266667+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, 59%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
LRC1006
20
Reputation points
answered 2025-01-16T07:56:23.7766667+00:00
ZoeHui-MSFT
40,356
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…
asked 2025-01-15T06:18:26.0133333+00:00
PANDEY Prashant
145
Reputation points
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…
asked 2025-01-09T04:49:19.9733333+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(201.6, 98%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
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…
asked 2025-01-08T06:50:56.34+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(12.8, 21%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBH%3C/text%3E%3C/svg%3E)
Bilal H. Bhatt
136
Reputation points
answered 2025-01-09T01:26:26.1866667+00:00
ZoeHui-MSFT
40,356
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…
asked 2025-01-06T12:18:11.1333333+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(6.4, 57.99999999999999%, 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)
Pavan G
0
Reputation points
commented 2025-01-07T02:02:46.3733333+00:00
LiHongMSFT-4306
30,591
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…
asked 2024-12-30T11:15:07.2+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(281.6, 24%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWA%3C/text%3E%3C/svg%3E)
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…
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
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:…
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
7,960
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
13,625
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
40,356
Reputation points