Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
454 questions
0 answers
Table.NestedJoin in Azure Analysis Services
We have an M/Power Query query in Power BI that uses Table.NestedJoin. However, we get errors when we try to use that same command in Azure Analysis Services. Does this command even work in AAS? I don't see any examples of it working properly. Is…
asked 2020-11-19T23:25:27.723+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-12-02T20:00:32.137+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 Services - current connection metrics
I am doing load testing of Azure analysis services where I have established 500 different sessions. When my code was running for these 500 connections, I monitored current connections metrics on Azure portal. There I saw max 15 current…
asked 2020-11-19T07:26:24.13+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, 52%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
Kalpana Chauhan
21
Reputation points
accepted 2020-11-26T15:47:46.077+00:00
Kalpana Chauhan
21
Reputation points
0 answers
Building data model (schema) from data in PowerBI (or via export to Excel)
Hi, I am seeking to build a data model (schema) for data tables that I currently have in PowerBI. I am able to export the data to Excel but have been having issues building a schema for the tables. Would appreciate any help for this please. Thanks!…
asked 2020-11-22T23:35:50.333+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, 60%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Rishi Sumit
1
Reputation point
commented 2020-11-25T20:33:24.027+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
Accoun Intelligence Azure Analysis services
Hi, Is there an equivalent of "Account intelligence" functionality available on Azure Analysis Services? If not, can you describe a workaround as to how to implement this? Many thanks
asked 2020-11-18T10:12:30.483+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, 34%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOA%3C/text%3E%3C/svg%3E)
Omar Ali
1
Reputation point
commented 2020-11-23T07:00:08.957+00:00
PRADEEPCHEEKATLA-MSFT
89,816
Reputation points Microsoft Employee
0 answers
Issue with method that returns Analysis services model
Hello, I have issues with extraction of model from Azure Analysis Services server using Powershell/C# methods and classes. In some cases, for some databases/cubes (no differences in the configuration itself), it returns empty Model (like there would…
asked 2020-11-10T09:49:43.36+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(278.4, 33%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Karol Kolodziejczyk
6
Reputation points
commented 2020-11-17T08:36:30.437+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.
Configure Azure Log Analytics agent to OMS log analytics gateway with powershell
Hi, as title says is it possible to Configure Azure Log Analytics agent(on-prem) to log analytics gateway with Powershell. I know what is possible to do with netsh winhttp set proxy <proxy>:<port> but then I think all…
![](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(259.20000000000005, 56.00000000000001%, 35%)' 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)
1 answer
How to configure VNet IP address range to firewall setting in Azure Analysis Services
I would like to restrict access of Azure Analysis service from IP address range as configured in Virtual Network setting. My query is that How to configure VNet IP address range to firewall setting in Azure Analysis Services Any reply will be…
asked 2020-11-09T15:31:06.963+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, 51%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
Krishna Dubey
21
Reputation points
commented 2020-11-13T00:47:47.653+00:00
MartinJaffer-MSFT
26,086
Reputation points
2 answers
Migrate a PBIX to Azure Analysis Services
I want to import a Power BI PBIX file into Azure Analysis Services. I don't see any recent information on how to do that. Is it possible? If so, how?
asked 2020-10-29T15:09:09.963+00:00
James H. Robinson
161
Reputation points
answered 2020-11-10T20:27:06.473+00:00
James H. Robinson
161
Reputation points
1 answer
Updating the Measure NullProcessing property through not updated in the cube while opening from SSDT
HI, I would like to update the NullProcessing property from Automatic to Preserve foreach (MeasureGroup measureGroup in cube.MeasureGroups) { foreach (Measure measure in measureGroup.Measures) { measure.Source.NullProcessing =…
asked 2020-10-23T07:36:16.003+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, 94%, 37%)' 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)
Narendra Reddy
1
Reputation point
commented 2020-11-10T12:49:15.7+00:00
Narendra Reddy
1
Reputation point
1 answer
One of the answers was accepted by the question author.
How to connect Azure analysis service from excel and powerBI online app using office 365
PowerQuery is not available in office 365 excel online version and unable to connect with Azure analysis service. while I can connect to Azure analysis service using Get Data in Excel desktop version but same feature is not available in online…
asked 2020-10-27T12:34:29.827+00:00
Krishna Dubey
21
Reputation points
accepted 2020-11-09T15:23:23.367+00:00
Krishna Dubey
21
Reputation points
1 answer
how to calculate historical usage of resources in azure
Hi guys, Hope you all are doing well. I need a help in calculating historical usage of azure resources like increase in data in adls with respect to time, processing time of databricks cluster, adf, syanapse resources for last 30 days in azure…
asked 2020-10-26T04:46:20.047+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, 21%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Ashima Gupta
66
Reputation points
commented 2020-11-05T06:52:19.497+00:00
Ashima Gupta
66
Reputation points
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
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
HimanshuSinha-msft
19,476
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
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,476
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.
454 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,142 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