Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
454 questions
1 answer
One of the answers was accepted by the question author.
Query to get a list of Paritions
All, Would the DMV -- $SYSTEM.TMSCHEMA_PARTITIONS -- on AAS give me a list of Partitions in a Analysis Service Tabular Model database? We are trying to see if the "Basic Tier B1/B2" Pricing Tier would help us get more value for the same…
![](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(137.6, 51%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Is there still a Azure Analysis Services Web Designer (as of 10/09/20)?
Hi, In some blogs I saw people talking about an Azure Analysis Services Web Designer, mostly around 2017. Today I cannot find this Web Designer from Azure Analysis Services portal. Does this tool still exist, and where can I find it today? Best…
asked 2020-10-09T20:07:05.007+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(54.400000000000006, 6%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bubenheimer, Martin
191
Reputation points
accepted 2020-10-09T20:19:09.84+00:00
Bubenheimer, Martin
191
Reputation points
0 answers
Azure Log Analytics or SQL Profiler for AAS?
I think you can use both SQL Server Profiler or Azure Log Analytics for Azure Analysis Services logging. But which one is the better option?
asked 2020-09-21T20:41:03.46+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(54.400000000000006, 35%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
James H. Robinson
161
Reputation points
commented 2020-10-09T00:02:18.313+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(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT
46,492
Reputation points Microsoft Employee
1 answer
DAX Approach to Inventory Problem?
I have data in Azure Analysis Services (Tabular) that looks like the following table. I need to create two calculated columns for the Date that the Inventory Changed and the Amount of the Inventory Change. I think and IF function can take care of me…
asked 2020-09-30T00:51:29.637+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(128, 80%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
james.h.robinson.csm@gmail.com
6
Reputation points
commented 2020-10-07T06:43:06.397+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(108.80000000000001, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HarithaMaddi-MSFT
10,136
Reputation points
0 answers
Is it possible to send data from WPF app to Azure analytics?
Is it possible to send data from WPF app to Azure analytics? If yes, which is the minimum Visualstudio version & .net framework version required ? which are the best analytic services offered by Azure which can used with WPF app?
asked 2020-10-01T09:42:53.153+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, 71%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Hi
1
Reputation point
commented 2020-10-07T00:46:17.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(172.8, 70%, 26%)' 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)
MartinJaffer-MSFT
26,086
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Analysis Services: How to add Role Members to Models?
Hi all, I'm a bit stuck with this part of my Azure AS journey. Any help is greatly appreciated. I have a model that I have built out in Visual Studio and I am successfully deploying to Azure AS. I am now trying to add my power users to give them access…
asked 2020-10-02T05:04:28.323+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(268.8, 16%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Me At Worky
21
Reputation points
accepted 2020-10-06T23:25:19.203+00:00
Me At Worky
21
Reputation points
1 answer
Do i have Azure Analysis Services in my tenant
Hi All, How do i know if i have Azure Analysis Services installed in my tenant? If not how to install AAS? Thanks
asked 2020-09-28T15:55:50.063+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, 7.000000000000001%, 10%)' 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)
bk
466
Reputation points
commented 2020-10-06T08:42:49.693+00:00
PRADEEPCHEEKATLA-MSFT
89,816
Reputation points Microsoft Employee
1 answer
AD group displays as long guid that starts with "obj:" when adding to Azure Analysis Services
I am trying to add a local domain security group to an azure analysis services instance as a Server Administrator. The group is synced with Azure AD and I am able to search for it by name and add it. When I attempt to add the group via the Azure…
asked 2020-09-30T21:20:56.417+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, 57.99999999999999%, 29%)' 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
6
Reputation points
answered 2020-10-01T17:48:51.493+00:00
Alfredo Revilla - Upwork Top Talent | IAM SWE SWA
27,461
Reputation points
0 answers
Azure Analysis Services - Direct Query not supported for OAuth2
I am trying to build a Tabular Model but when I try to connect Azure SQL DW in DirectQuery mode "Failed to save modifications to the server. Datasource has authentication kind OAuth2. This is not supported in DirectQuery 1400 mode" As per…
asked 2020-08-21T20:22:34.163+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, 51%, 18%)' 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)
Ajit Kumar Singh
1
Reputation point Microsoft Employee
commented 2020-10-01T07:15:08.66+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(102.4, 52%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kjetil Smistad
1
Reputation point
1 answer
Azure DevOps - Test execution limitation
Hi, We are experiencing multiple issues using a manual testing module in DevOps. We have created a number of distinct Test Plans Group and Test Suite by function. We have the following needs where DevOps fails to provide any solution. Appreciate if we…
asked 2020-09-30T23:02:21.727+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, 44%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBN%3C/text%3E%3C/svg%3E)
Biswas, Niloy @BlueScope
1
Reputation point
answered 2020-10-01T06:29:17.987+00:00
Leon Laude
85,791
Reputation points
0 answers
Error when importing Power BI Premium Model Into Azure Analysis Services
I have recently created an Azure Analysis Services model and created a connection with my power BI premium model. This PBI model has the XMLA set to read/write. I have successfully managed to create a connection between the two models using the PBI…
asked 2020-09-23T19:14:06.927+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, 33%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
VITOR SILLOS ALONSO
1
Reputation point
commented 2020-09-29T09:07:16.247+00:00
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
On premise data gateway connection issue
I have two global admin account with two different domain, and I want to use a single gateway for the CSV file access. when I log in with the first account then the second account gateway connection is out of the network. Please help me with the…
asked 2020-09-28T08:44:18.863+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(128, 62%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Serosoft
1
Reputation point
answered 2020-09-29T06:03:27.57+00:00
PRADEEPCHEEKATLA-MSFT
89,816
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
SQLServer 2019, Polybase and Tabular Model
All, From SQL Server 2019, how do I connect to SQL Server Analysis Server (Tabular Model)/Azure Analysis Service using "CREATE EXTERNAL DATA SOURCE". I would like to connect to it using Polybase and extract data from the Tabular data model.…
3 answers
One of the answers was accepted by the question author.
Analysis Services Tabular Model excel in sharepoint
I have created an analysis services tabular model. It has a database connection and a couple of excel files as data sources. When syncing the azure analysis services from the portal, the data does not update. It only updates if I publish from visual…
asked 2020-09-16T11:58:48.063+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(131.20000000000002, 62%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
Palios, Jason
81
Reputation points
commented 2020-09-27T11:21:33.917+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(284.8, 81%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Juli Lis
1
Reputation point
1 answer
Impersonation of Oracle Data Source in Azure Analysis Services
Hi All, We are using Azure Analysis services for building cubes, 1500 level compatibility. I am trying to understanding the impersonation settings while connecting to different data sources... For On-Prem SQL Server - We are using SQL Auth and…
asked 2020-09-08T15:20:24.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(275.2, 3%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPY%3C/text%3E%3C/svg%3E)
Praveen Yakkala
1
Reputation point
commented 2020-09-23T23:19:10.15+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(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft
19,476
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure Analysis Service - Memory Consumption
All, We are currently hosting Azure Analysis Service (AAS) with S0 pricing tier and this gives us 10GB of RAM. In a On-Prem setup of SQLServer Analysis Service, the engine itself would consume fair amount of RAM and I'm seeing about 1GB of RAM being…
2 answers
Azure Analysis Services - Rolling Back Changes to Data
Is there to a way to roll back changes to an AAS model after it has been processed? I don't see any references to this anywhere.
asked 2020-09-17T15:46:09.997+00:00
James H. Robinson
161
Reputation points
commented 2020-09-21T17:53:16.557+00:00
KranthiPakala-MSFT
46,492
Reputation points Microsoft Employee
1 answer
Azure Analysis Services Partitions and Query Performance
From what I understand, partitions in Azure Analysis Services do not dramatically improve Direct Query performance. Is that correct?
asked 2020-09-14T14:38:16.17+00:00
james.h.robinson.csm@gmail.com
6
Reputation points
commented 2020-09-19T10:20:41.767+00:00
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
Deleting Specific Rows from a Tabular Table
How can I delete specific rows from an AAS Tabular table? I basically want to do the equivalent of DELETE/FROM/WHERE in SQL.
asked 2020-09-14T18:58:53.927+00:00
james.h.robinson.csm@gmail.com
6
Reputation points
commented 2020-09-19T10:20:13.29+00:00
HarithaMaddi-MSFT
10,136
Reputation points
2 answers
One of the answers was accepted by the question author.
Deleting alreday published Tabular Models from Azure Portal
I have few Tabular Models published on azure resource which I need to delete as clean up process. Please note I DO NOT want to delete resource rather models in those resources. I do not see any delete option when I right click on models in resource,…
![](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, 11%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)