Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
444 questions
1 answer
Azure Analysis Services/Azure DevOps
Does every new Azure Analysis Services model require a new Azure DevOps repo? Also does every modification to an existing AAS model require a new branch to the ADO repo?
asked 2020-08-18T16:19:01.013+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-08-24T05:13:40.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(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
Azure Analysis Services model deploys without data
First, I processed the tables in my Azure Analysis Services model using Visual Studio. Data was loaded into each table. But when I deploy that model to the AAS server, no data gets deployed. What am I doing wrong?
asked 2020-08-11T03:32:34.5+00:00
James H. Robinson
161
Reputation points
commented 2020-08-17T10:12:56.647+00:00
PRADEEPCHEEKATLA-MSFT
85,351
Reputation points Microsoft Employee
1 answer
Azure SQL Database queries timing out after 15 minutes.
I have several Logic Apps and SSAS partitions that execute queries which take longer than 15 minutes to run. As of this morning a lot of them have started to timeout at around the 10 - 15 minute mark and I have no idea why. Here's the error message that…
asked 2020-08-03T11:04:29.943+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(233.6, 32%, 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)
Matthew Modget
26
Reputation points
answered 2020-08-13T03:14:27.68+00:00
Mike Ubezzi
2,776
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure Analysis Services tabular model alerts
Hello, We refresh our tabular models on Azure from SSMS through PowerShell scripts. But apparently the jobs don’t fail if the script contains some errors. So sometimes we have cases when all is running OK but our models on AzureAS are not being…
![](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(41.6, 16%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
3 answers
azure analysis service: how to start and pause service with on premise powershell
Hello All, I need your help. I have an azure analysis service that I want to start and pause at different times of the day. I want to use Powershell to execute a script to do this task. Do you know how I can do it? Thank you for your help
asked 2020-07-29T22:53:27.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(217.60000000000002, 57.99999999999999%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHL%3C/text%3E%3C/svg%3E)
H. Laguide
1
Reputation point
commented 2020-08-06T07:04:43.957+00:00
PRADEEPCHEEKATLA-MSFT
85,351
Reputation points Microsoft Employee
1 answer
Azure Analysis Service use postgresql as Data Source
Hello, I want to use the Azure Analysis Service (AS) with an on-premise postgresql database. To do this, I tried two approches : Create a tabular model on Azure AS. Migrate my local postgresql to Azure db for postgrsql. Then connect the Azure AS with…
asked 2020-07-28T12:55:03.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(9.6, 10%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
ZDUAN
1
Reputation point
commented 2020-08-04T20:29:50.157+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,442
Reputation points Microsoft Employee
1 answer
Azure Analysis Service Error: InvalidConnectionCredentials
Hello, I hope you are well. I am working on a tabular model deployed on Azure Analysis Service. My model is based on an on premise SQL server. When I process the model I get this error message: Failed to save modifications to the server. Error…
asked 2020-07-29T17:21:56.297+00:00
H. Laguide
1
Reputation point
commented 2020-08-04T05:34:49.833+00:00
HarithaMaddi-MSFT
10,136
Reputation points
0 answers
refresh of model doesn't finish with out any errors
So let me try to describe the scenario. We have a model, that is around 10 Gb. Source is an oracle database. A normal refresh takes somewhere between 40 and 50 minutes. We do a full refresh of the complete model. The model is deployed…
asked 2020-07-22T15:17:26.517+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(169.60000000000002, 84%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Arthur Steijn
56
Reputation points
commented 2020-07-30T06:14:05.61+00:00
KranthiPakala-MSFT
46,442
Reputation points Microsoft Employee
1 answer
Default Aggregation Function for Azure AS Measures
According to Microsoft's Azure Analysis Services documentation: "Measures can be based on standard aggregation functions, such as AVERAGE, COUNT, or SUM." But which aggregation function is the default? Is it SUM? Also, can the default…
asked 2020-07-22T16:32:29.913+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-07-29T05:04:47.077+00:00
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
Azure Analysis Services Role assignment
We developed a tabular model in Azure AS and Power BI live report on top it. What role should we assign on Azure AS to end user to access Power BI report reader/contributor didn't work so far. Only when we make that user as Azure AS admin then only…
asked 2020-07-08T08:57:42.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(281.6, 31%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECP%3C/text%3E%3C/svg%3E)
Chandra Prakash Matam
21
Reputation points
commented 2020-07-28T14:37:11.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(25.6, 70%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Saubhagya Nayak
1
Reputation point
2 answers
Architectual Question (ADLS, Azure Synapse, AAS, Power BI)
We are using the following: Source data stored in ADLS (Blob Storage) Azure Synapse (sort of a staging layer) Azure Analysis Services (semantic layer) Power BI (for users to create their own vizualizations based on the AAS semantic layer) …
asked 2020-07-26T20:46:49.767+00:00
james.h.robinson.csm@gmail.com
6
Reputation points
commented 2020-07-28T14:32:07.89+00:00
Saubhagya Nayak
1
Reputation point
1 answer
Is there a deployable sample showing how to enable the reviewing of questions asked at a QnAMaker bot?
I need to be able to review questions asked at my QnAMaker bot. Is there a sample which shows how to do this? I currently use a bot generated for me after publishing my QnAMaker service, but the code generated doesn't match the code which shows how to…
asked 2020-07-20T16:39:01.71+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, 82%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Guy Barker (CELA)
1
Reputation point
commented 2020-07-23T21:18:32.78+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(214.4, 45%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
GiftA-MSFT
11,161
Reputation points
1 answer
How to do parallel development on Single Tabular Model
How to do parallel development on Single Tabular Model ? Even though the Tabular model visual studio project can be source control using Team Service but still how can multiple developer merge their code change to the single Solution ? Whats are…
asked 2020-06-17T05:44:45.53+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-07-21T13:20:45.723+00:00
Arthur Steijn
56
Reputation points
1 answer
Install third party libraries in Azure Databricks
Hello, I am trying to install a library "pythonnet" in Azure Databricks. I tried installing it through PyPI, through Python Wheel option and also the JAR option. None of these works for me. I need to connect databricks notebook to Azure…
asked 2020-06-25T19:30:03.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(134.4, 43%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Shivani Vyas
21
Reputation points
commented 2020-07-13T21:22:53.083+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,061
Reputation points
0 answers
Azure AS Model Duplication
Hello all, I'm currently developing an Azure Analysis services model with my team. We are now using a blob storage as the source of data. The model itself connects as it should, my problem happens when I want to share my model with a colleague (still…
asked 2020-06-26T14:29:28.037+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-07-07T19:34:35.327+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,386
Reputation points Microsoft Employee
1 answer
Read Percentage question
Under Networking and the Read Percentage in the My Analytics is the percent how many of the emails you have read from the correspondent or how many emails the correspondent has read of yours?
asked 2020-06-24T15:37:40.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(214.4, 36%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
Brittany Becerra
1
Reputation point
answered 2020-06-24T17:43:44.383+00:00
HimanshuSinha-msft
19,386
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How to display the count of accurance of text seperated by commas in a column in Power Bi live connection
This is a column from a table from live connection this is what the output i am getting. Where i am trying to create a chart like this. what is the perfect way to get this result in analysis service live connection. i cannot edit or split…
asked 2020-06-16T10:54:09.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(300.8, 2%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
A S, Irfan Sultan
21
Reputation points
accepted 2020-06-24T08:29:42.857+00:00
A S, Irfan Sultan
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Used Dynamics 365 as source (Odata API 9) in SSAS tabular model
I'm trying to create a new SSAS tabular model with Dynamics 365 as source. When I try the connection with Odata API 9.0 or 9.1 in Visual Studio, it's not working (see file in attached for the error message) ---------- Everything is working…
asked 2020-06-10T10:13:27.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(57.599999999999994, 1%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECF%3C/text%3E%3C/svg%3E)
Cedric FK_finelog
206
Reputation points
commented 2020-06-23T09:06:35.347+00:00
Cedric FK_finelog
206
Reputation points
1 answer
Azure Analysis service: estimate model size
Hello, I am working on a migration from a multidimensional cube to a tabular cube on Azure. I would like to be able to assess the size of the model in order to predict pricing on Azure Analysis Service. Is there a way to predict the size of the…
asked 2020-06-03T08:52:43.56+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(249.60000000000002, 87%, 34%)' 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)
Lidou
6
Reputation points
commented 2020-06-15T21:27:13.177+00:00
HimanshuSinha-msft
19,386
Reputation points Microsoft Employee
5 answers
Let SSAS connect to Synapse without enabling 'Allow Azure services'
Hi all, I want to enable my Azure Analysis Services Cube to process with data from Synapse. But I want to disable the 'Allow all Azure Services' option on the firewall. So now I'm thinking about adding an action to my Data Factory Pipeline (self…
![](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(44.800000000000004, 63%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
