Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
443 questions
1 answer
One of the answers was accepted by the question author.
Azure Analysis Services: Columns vs. Rows
What causes a larger performance hit for AAS, having lots of columns or having lots of rows? For example, my client wants an AAS model that could potentially have 2,000+ columns. Would that cause a large performance hit on AAS?
asked 2020-10-27T22:05:38.907+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
accepted 2020-11-03T14:29:41.573+00:00
James H. Robinson
161
Reputation points
0 answers
Replicate Power BI model & setup in Azure
We are currently using Power BI and want to explore moving a semantic model to Azure Analysis services and I cant seem to grasp the concept or azure items to make this possible.. Currently on Power BI: Datawarehouse is in AWS, Mods/datamarts are…
asked 2020-10-08T14:25:42.377+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(147.20000000000002, 47%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
KSeth
1
Reputation point
commented 2020-10-29T19:02:49.767+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,376
Reputation points Microsoft Employee
1 answer
Out of Memory (Analysis Service Database Processing)
I am often running into "Out of Memory Error", while database full process. Could you please recommend the solution ? What are the tip for Analysis Service maintenance ? Thanks
asked 2020-10-22T19:06:11.953+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(137.6, 88%, 23%)' 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)
Boiler
1
Reputation point
commented 2020-10-28T15:27:26.83+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
1 answer
One of the answers was accepted by the question author.
Azure Analysis Services: One Table, Multiple Models
Is it possible to use one table in multiple models? For example, I have more than one model that will use the same Customers table. If I have to make a modification to Customers, I would have to modify EACH Customers table in EACH model. But if I…
asked 2020-10-27T21:57:39.417+00:00
James H. Robinson
161
Reputation points
accepted 2020-10-28T13:23:52.203+00:00
James H. Robinson
161
Reputation points
0 answers
How to call websocket api and make a data set based on time?
I want to call websocket api from data anlytics or data factory which gives continous data from api. i want to read that data and based on time after every 5 minutes want to take out open high low and close values from that set. i can able to do it using…
asked 2020-10-11T07:36:44.293+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, 13%, 38%)' 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)
ashish fugat
11
Reputation points
commented 2020-10-22T16:58:21.693+00:00
HimanshuSinha-msft
19,376
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure Analysis Services: Purging Data
I want to make sure there are only 90 days of data in my Azure Analysis Services (AAS) model. I'm thinking about using Power Query/M to only filter the most recent 90 days and then doing a Process Full. Is that the best approach to this? If so, how…
asked 2020-10-15T14:33:26.647+00:00
James H. Robinson
161
Reputation points
accepted 2020-10-21T13:46:38.213+00:00
James H. Robinson
161
Reputation points
2 answers
One of the answers was accepted by the question author.
Cannot connect Visual Studio 2019 SSDT to Azure Analysis Services
Hi, I have set up the adventureworks sample model in Azure Analysis Services. Firewall is off. I succesfully connected Excel, Power BI Desktop, Power BI Service and SSMS. This all works fine. Now I want to add a KPI to this model using Visual…
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
443 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,830 questions
asked 2020-10-09T14:29:52.87+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-16T20:59:22.82+00:00
Bubenheimer, Martin
191
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Analysis Service and Performance
All, We have an Azure Analysis Service of S0 Pricing Tier in production. I took a look at the Metrics in the Portal due to performance reasons and here is what I found: [1] Max QPU for Azureaasp1 is frequently 40QPU [2] Max Memory: Cleaner Memory…
![](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.
Cannot add calculation group to SSAS Tabular 1500 with direct query to SQL server
Hi, I am not able to create calculation groups on my direct query model. My tabular model is based on a single db source but I cannot seem to solve for the error when I need to create calculation groups. Neither tabular editor or visual studio are…
asked 2020-09-29T06:26:35.977+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, 94%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Tlou, Violet
21
Reputation points
accepted 2020-10-12T06:35:53.973+00:00
Tlou, Violet
21
Reputation points
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…
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
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
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,437
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
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,051
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
461
Reputation points
commented 2020-10-06T08:42:49.693+00:00
PRADEEPCHEEKATLA-MSFT
84,531
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,426
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,716
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