Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
436 questions
0 answers
how to assign roles in Azure Analysis Services (AAS) to visualize information in power bi by row level security either way (Dynamic or static)?
How to assign roles in azure analysis services to visualize information in power bi by row level security (Dynamic or static)? Do you have to assign the role from visual studio, from SQL Server Management Studio (SSMS) or from both? We have tried to…
asked 2023-08-25T22:22:06.3966667+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(96, 2%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIS%3C/text%3E%3C/svg%3E)
Isaac Suarez Maldonado
0
Reputation points
commented 2023-09-01T22:52:06.9533333+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, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache
20,026
Reputation points
2 answers
One of the answers was accepted by the question author.
How to use the format string function in the column properties to do custom formatting
Hello, I have a date_key column with data type whole number and formatted as Text as shown below. I want to apply this same logic to the date_key column in another table for my measure to work. I don't remember how to use the custom formatting and…
![](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(118.4, 88%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Is there a approach to delta load to SSAS Tabular model ?
I have a Scenario , Where i refresh the cube (Process FULL or Process DATA) at certain interval, However my goal is to achieve incremental delta load to the partitions by allowing the partition to be refreshed with newly added data . The process ADD…
asked 2023-05-03T21:04:59.8266667+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(38.4, 64%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
swabhiman das
20
Reputation points
accepted 2023-08-26T00:04:20.2333333+00:00
swabhiman das
20
Reputation points
1 answer
One of the answers was accepted by the question author.
why does cloud azure analysis services need a gateway
Hi. I'm looking at some info on gateway uses and was surprised to see that the cloud azure analysis services needs a gateway. Why would that be true if your cube is in the cloud? And if it isnt, why would someone be using cloud services for analysis…
![](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(236.8, 9%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
2 answers
Can't set planned refresh on PowerBI dataset (greyed out)
Hi, iam using a powerbi dashboard which is connected live to a azure analysis services tabular model. Initially i pinned a specific tile on dashboard and create a new dashboard out of it. After doing this i was able to setup alerting with the condition…
asked 2023-08-07T12:32:16.8633333+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(182.40000000000003, 46%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGK%3C/text%3E%3C/svg%3E)
Gökhan Demirci
40
Reputation points
answered 2023-08-23T06:08:29.8733333+00:00
AnnuKumari-MSFT
30,361
Reputation points Microsoft Employee
1 answer
Tabular model calculation item Ordinal property not changing
I am using Visual studio 2019 and SSDT to develop a tabular model. I have created calculated groups and calculated items. I have also created an Ordinal column to sort the calculated items by a certain order When I set the Ordinal property of a…
asked 2023-04-09T22:45:32.19+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, 96%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Syed Shah
0
Reputation points
commented 2023-08-22T16:52:56.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(86.4, 36%, 18%)' 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)
BhargavaGunnam-MSFT
25,876
Reputation points Microsoft Employee
1 answer
How to create field parameters at the Azure Analytic services model?
I'm trying to create a tabular model at the Visual Studio that has field parameters at the power BI side. I have to create the model at the visual studio and I'm not sure is this a limitation from AAS or power BI? I found this solution but not…
asked 2022-10-18T20:09:24.9+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(41.6, 26%, 14%)' 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)
S79
6
Reputation points
answered 2023-08-17T13:10:23.1666667+00:00
Amira Bedhiafi
14,571
Reputation points
1 answer
One of the answers was accepted by the question author.
Getting data from QAD ERP system is challenging
Hi all, I have been working on the data warehouse project where I am trying to integrate multiple ERP system from different country using Azure data factory as my orchestrate tool and Azure sql database as my storage and transformation layer. Azure…
asked 2023-08-10T08:28:41.3766667+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(96, 75%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELV%3C/text%3E%3C/svg%3E)
Lavanya Vijay
20
Reputation points
accepted 2023-08-16T05:27:49.49+00:00
Lavanya Vijay
20
Reputation points
1 answer
Allow Azure Analysis Service & Azure DevOps through Azure Firewall
I am using Azure Basic Firewall and have applied DNAT rules to allow SQL access for specific IP ranges. However, this has caused issues with communication between Analysis Service and Azure DevOps. When I remove the IP restriction and set the Source to…
asked 2023-08-11T11:12:23.82+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, 85%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Muhammad Hammad Naeem
45
Reputation points
answered 2023-08-14T23:43:54+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
Can you use Visual Studio Community to develop for Azure Analytics Services?
Licensing terms say: · Any number of your users may use the software only for Microsoft SQL Server development when using the SQL Server Data Tools or the extensions “Microsoft Analysis Services Projects”, “Microsoft Reporting Services Projects”, or…
asked 2021-10-14T14:03:29.63+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(259.20000000000005, 76%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYB%3C/text%3E%3C/svg%3E)
Yor Braakman
6
Reputation points
answered 2023-08-06T12:04:50.77+00:00
Amira Bedhiafi
14,571
Reputation points
2 answers
Azure Analysis Service Role Creation using TMSL/XMLA
Hi Everyone, As per Microsoft site : https://learn.microsoft.com/en-us/analysis-services/tmsl/createorreplace-command-tmsl?view=asallproducts-allversions createOrReplace for role creation is done only for one role , if we have multiple roles can someone…
asked 2023-07-25T16:37:18.93+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(256, 19%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Andy
1
Reputation point
answered 2023-07-26T05:26:28.2766667+00:00
PRADEEPCHEEKATLA-MSFT
76,511
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
What is the best way to transform raw data coming from synapses to Power BI
I am into a project to bring all data from F&O to synapses and then load to power BI to create multiple dashboard for different modules and it will be used by different companies . So I would like to understand what will be the best platform to…
asked 2023-07-19T10:21:43.7766667+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(195.2, 86%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Athira Reghuraman
60
Reputation points
commented 2023-07-24T09:55:43.6966667+00:00
Athira Reghuraman
60
Reputation points
1 answer
One of the answers was accepted by the question author.
Analysis service error
Did anyone notice this error while refreshing the azure analysis services? Error Details<br/><p style='color:red'>[{"message":"Retry attempts for failures while executing the refresh exceeded the retry limit set on the…
asked 2023-07-14T15:29:47.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(265.6, 9%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB4%3C/text%3E%3C/svg%3E)
Bharath-4205
80
Reputation points
accepted 2023-07-24T05:18:42.52+00:00
Bharath-4205
80
Reputation points
1 answer
One of the answers was accepted by the question author.
analysis services native query
Hello, when trying to import the data using the native query, we are getting an error "native queries aren't supported by this value". We are using ODBC here. my understanding is ODBC allows native queries. Appreciate your inputs here
asked 2023-07-14T15:38:46.7433333+00:00
Bharath-4205
80
Reputation points
accepted 2023-07-24T05:18:27.4966667+00:00
Bharath-4205
80
Reputation points
1 answer
How to connect to Azure Serverless Pool from On-Prem SSAS Tabular using Visual Studio
Hi, We have an On-Prem SSAS Tabular database and we need to be able to setup a new datasource to an Azure Serverless SQL Pool. I tried all the different providers but there doesn't seem to be a way to connect. Using SSMS, I can connect using Azure…
asked 2023-07-10T13:23:10.4766667+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(204.8, 47%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Cabral, Scott
21
Reputation points
edited the question 2023-07-21T09:28:39.14+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(140.8, 78%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tianyu Sun-MSFT
27,106
Reputation points Microsoft Vendor
1 answer
Alternative method to Add-AzAnalysisServicesAccount for connecting to Azure Analysis Service using MSAL
What is an alternative method to Add-AzAnalysisServicesAccount module for connecting to Azure Analysis Service from a PowerShell task using MSAL? We are currently using the Add-AzAnalysisServicesAccount module which internally uses ADAL, however, as ADAL…
asked 2023-07-14T05:20:03.63+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, 77%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Rajmohan Ponnurangam
0
Reputation points
edited an answer 2023-07-20T18:46:58.54+00:00
BhargavaGunnam-MSFT
25,876
Reputation points Microsoft Employee
1 answer
How to get the Schema of list of Parquet files in a folder
Hi All, I have to Create a file which will have the Parquet File name and its Schema into a CSV file. I can use Metadata and Child Items to get the list of files in a folder. But getting the Schema of each file is where i am stuck can you please suggest…
asked 2023-07-14T16:58:25.4833333+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(35.2, 32%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJN%3C/text%3E%3C/svg%3E)
Jaganathan, NK. (Naveen Kumar)
0
Reputation points
commented 2023-07-20T16:52:23.22+00:00
ShaikMaheer-MSFT
37,816
Reputation points Microsoft Employee
1 answer
How to see the initial configuration of an Azure resource
Hi, we created an instance of analysis services, but we can't find what the initial configuration was when looking at the creation JSON in the activity log. How would we find what the initial configuration would have been?
asked 2023-07-11T18:55:45.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(147.20000000000002, 12%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Richard Duane Wolford Jr
201
Reputation points
answered 2023-07-11T21:27:59.5766667+00:00
QuantumCache
20,026
Reputation points
0 answers
How come for some people their name is added to the AAS model like xxxx_name_xxxxx when they deploy the AAS model?
It seems that for some people when they deploy an AAS model to the server their name is added to the model name like xxxxxx_name_code instead of just publishing the model name xxxxxx. Because of this there seem to be multiple model versions rather than…
asked 2023-06-21T14:51:29.4133333+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, 68%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ8%3C/text%3E%3C/svg%3E)
JKmag-8992
0
Reputation points
commented 2023-07-10T06:09:20.29+00:00
PRADEEPCHEEKATLA-MSFT
76,511
Reputation points Microsoft Employee
1 answer
How can I automate partition creation in Azure Analysis Services without using SPN Certificates?
I am currently using a setup where I create partitions in Azure Analysis Services database tables using Automation Runbooks, where we connect to AAS using SPN Certificates. Since Azure will be discontinuing the use of Certificates for authentication from…
asked 2023-06-14T05:41:23.8233333+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, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
commented 2023-07-06T12:06:29.1466667+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, 39%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SwathiDhanwada-MSFT
17,236
Reputation points