Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
438 questions
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
![](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-04T05:34:49.833+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,126
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
21
Reputation points
commented 2020-07-30T06:14:05.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(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,422
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,126
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,151
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
21
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,026
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,381
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,381
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,381
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)
2 answers
One of the answers was accepted by the question author.
Which sytemService is Analysis Services in Public Service Tags IP JSON
Hi, I found a JSON which contains all Azure IP's (www.microsoft.com/en-us/download/details.aspx?id=56519). But I want to find it which IP's are used here for 1 specific region (West Europe) and for Azure Analysis Services. But I can't find that in this…
1 answer
ADOMD. Net Product Version 18.7.0.1 trows exception when extracting data from Azure Analysis Service
Hi, I’m using ADOMD. Net to execute a MDX query in Azure Analysis Service. The code worked fine until recently, but stopped working when the new version of ADOMD was installed on the computer. I tried on two systems: one has Net Framework 4.5…
asked 2020-05-18T14:31:46.307+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, 22%, 36%)' 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)
SP
1
Reputation point
commented 2020-05-29T22:07:53.573+00:00
KranthiPakala-MSFT
46,422
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
In Analysis Services, turning the AlwaysUseGateway property True/False
Hi, We have a requirement to set the AsPaaS\AlwaysUseGateway property to true and when not in use, turn the property to false In simple words, we want to automate its value,setting it to true/false whenever we require Is there any way to…
asked 2020-05-08T08:20:13.757+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, 57.99999999999999%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Ramya Harinarthini_MSFT
5,306
Reputation points Microsoft Employee
accepted 2020-05-08T08:27:19.047+00:00
Ramya Harinarthini_MSFT
5,306
Reputation points Microsoft Employee
1 answer
Unable to create analysis services resource
![5232-analysis-service-error.png][1]
asked 2020-03-21T07:57:27.84+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, 79%, 31%)' 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)
sachin kumar
1
Reputation point
commented 2020-05-08T05:04:07.607+00:00
Vaibhav Chaudhari
38,591
Reputation points