Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
450 questions
1 answer
One of the answers was accepted by the question author.
Azure Analaysis service error
When importing data using native query, we are getting "native queries aren't supported by this value" my understanding is ODBC allows using native queries. Please let me know whether native query work with ODBC in Azure analysis…
asked 2022-12-07T04:43:17.673+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, 45%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP3%3C/text%3E%3C/svg%3E)
Pavankumar-3526
306
Reputation points
accepted 2022-12-08T03:18:49.78+00:00
Pavankumar-3526
306
Reputation points
1 answer
One of the answers was accepted by the question author.
Visual Studio Licence for Azure Analysis Services
I'm working in a big company as a BI developer. I'm new in Analysis Services but when I unstood it right, I need a Version of Visual Studio to use SSDT. I only want to use the Visual Studio for Azure Analysis Services. Do I have to pay for the Visual…
asked 2022-12-05T15:54:06.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(41.6, 97%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
de Bernardo, Mark
21
Reputation points
accepted 2022-12-06T06:22:06.297+00:00
de Bernardo, Mark
21
Reputation points
1 answer
Process AAS Model memorry error
Hello, please I really need your help, each time I try to process my model(VS) I get this error Failed to save modifications to the server. Error returned: 'There's not enough memory to complete this operation. Please try again later when there may…
asked 2022-11-30T18:24:30.627+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, 81%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBU%3C/text%3E%3C/svg%3E)
Back up
6
Reputation points
commented 2022-12-03T01:18:05.203+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)
Bhargava-MSFT
30,816
Reputation points Microsoft Employee
1 answer
Odbc.Query on AAS through Visual Studio (An M partition uses a data function which results in access to a data source different from those defined in the model)
Good afternoon, Some of our developers are facing a very annoying issue when working with Visual Studio (2019) They create a simple AAS cube where they define an ODBC Teradata connection , let's say "Odbc/authentication=td2;dsn=BIPDEV" …
asked 2022-12-01T17:21:08.38+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(124.80000000000001, 81%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
MARTIN PEREZ Miguel
41
Reputation points
commented 2022-12-02T20:49:24.177+00:00
Bhargava-MSFT
30,816
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Native Query in Analysis Services with ODBC
Hi, We are trying to import data by using a native query in Visual Studio ; we use on our side ODBC for our Teradata servers Problem is when we try to create the expression, we receive a popup saying that "native queries aren't supported by…
asked 2022-10-17T19:52:22.687+00:00
MARTIN PEREZ Miguel
41
Reputation points
accepted 2022-12-01T17:11:47.54+00:00
MARTIN PEREZ Miguel
41
Reputation points
1 answer
AAS refresh failure via ADF
HI All, I am following the below blog to process AAS via managed identity: https://medium.com/ricoh-digital-services/process-azure-analysis-services-models-with-azure-data-factory-v2-d7c6288f352c The only change that i implemented is rather…
![](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(291.2, 27%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
How pricing will be calculated for data which is stored from dataverse table using azure synapse link
Hi folks, I am storing stale data from data verse table to azure data lake storage using Azure synapse Link. which actually stores data day by day for the whole year. ex, each day it transforms 10-50 records to azure data lake. So my…
asked 2022-10-28T07:02:29.8+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, 26%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Charles Michel Beskie (For Azure)
46
Reputation points
commented 2022-11-18T07:31:11.483+00:00
Charles Michel Beskie (For Azure)
46
Reputation points
1 answer
Chaos Studio - Error opening experiment designer
Home > Chaos Studio > Experiments > Create When I go to 'Experiment designer', I'm getting an error page. Text: "{ "shellProps": { "sessionId": "3e609a864ea04585b2a1096017d9e150", …
asked 2022-11-14T16:40:12.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(156.8, 35%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
Orla
1
Reputation point
commented 2022-11-17T10:02:26.18+00:00
PRADEEPCHEEKATLA-MSFT
88,716
Reputation points Microsoft Employee
0 answers
Azure Analysis service Exception has been thrown by the target of an invocation
I recently downloaded Microsoft Analysis Services Projects 2022 from https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftAnalysisServicesModelingProjects2022&ssr=false#qna to VS2022 community and now I can deploy any package I am…
asked 2022-11-08T14:09:43.69+00:00
Gabe
1
Reputation point
commented 2022-11-14T09:24:47.997+00:00
PRADEEPCHEEKATLA-MSFT
88,716
Reputation points Microsoft Employee
0 answers
Is NETWORKDAYS function available on DAX for AAS model?
Hello I'm trying to use NETWORKDAYS function inside DAX code in my AAS model, but it is giving a Failed to resolve name error. Is the function available for usage within AAS models. Is there a specific compatibility level requirement? Thanks…
asked 2022-11-08T07:50:25.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(268.8, 48%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
Visakh
211
Reputation points
commented 2022-11-14T09:22:56.237+00:00
PRADEEPCHEEKATLA-MSFT
88,716
Reputation points Microsoft Employee
1 answer
Analysis Services REST API missing location header
The REST API to refresh the tabular model (https://video2.skills-academy.com/en-us/azure/analysis-services/analysis-services-async-refresh) is supposed to return a Location header that can be used to obtain progress information. This has now stopped working.…
asked 2022-10-19T15:02:35.853+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, 53%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIJ%3C/text%3E%3C/svg%3E)
Ivan Johannessen
11
Reputation points
commented 2022-11-11T17:15:54.703+00:00
Kazi Sabbir
1
Reputation point
2 answers
One of the answers was accepted by the question author.
How can I copy and duplicate an AAS cube?
We an Azure Analysis Services Tabular model which pulls from our Azure Synapse database. We want to create a duplicate of this cube with the exact same measures, calculations, etc. so that we can add tables that we don't want to add to the original one.…
asked 2022-08-02T13:55:05.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(35.2, 79%, 13%)' 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)
amzzz
61
Reputation points
answered 2022-11-04T09:59:32.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(28.799999999999997, 6%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Martin Rieth
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Azure Analysis Services Processing Error wo additional details
Error when refreshing Azure Analysis Service one of tabular models using On-Prem Gateway with Azure Function & Logic Apps. Gateway version 3000.146.10 (October 2022) Exception message: Failed to save modifications to the server. Error returned:…
![](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(252.8, 18%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
0 answers
Azure Analysis Services - Refresh Tabular Model Partition in "Add Mode" from Azure Data Factory
Hi, we are using Azure Data Factory to automate ETL and management of an Azure Analysis Services Tabular Model. We want to do an incremental refresh of the Sales Fact table on a regular basis, and given its size we only want to process additional…
asked 2022-09-30T08:18:12.54+00:00
Peter Rush
41
Reputation points
commented 2022-10-20T06:56:41.057+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,462
Reputation points Microsoft Employee
1 answer
Decision making factors for migrating SSAS from Azure VM to Azure Analysis Services
Hello, Recently we have upgraded our SSAS resources. Currently our SSAS is on Azure VM costing us based on this VM type 'Standard E32-8s_v3'. I am looking for a way to save more cost by selecting a better option. What can be a good option…
asked 2022-07-29T04:39:16.26+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(246.4, 68%, 33%)' 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)
SRSYD
1
Reputation point
commented 2022-10-20T04:16:56.933+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, 43%, 19%)' 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)
Sumayya Sayed
1
Reputation point
1 answer
Getting started with monitoring of analysis service
I use a managed analysis services server in my subscription and would like to get started with some monitoring, What would be the most common and important metrics I should look at when defining alert rules? I reviewed this article and didn't…
asked 2022-10-19T07:29:42.887+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(262.40000000000003, 80%, 35%)' 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)
AssafL
1
Reputation point
answered 2022-10-19T10:58:39.953+00:00
Stanislav Zhelyazkov
23,501
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
Data modification in log analytics before archiving it.
I have set up a connection between Azure DevOps and Log analytics workspace to get the audit data as a maintenance purpose. But before storing/archiving the data, I need to follow the GDPR rules i.e I have to remove the personal data before storing it…
asked 2022-10-12T09:41:20.623+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(307.2, 4%, 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)
Abhishek Singh (Contractor)
41
Reputation points
accepted 2022-10-17T08:30:48.73+00:00
Abhishek Singh (Contractor)
41
Reputation points
2 answers
One of the answers was accepted by the question author.
Hiding AAS columns "...not intended to be used for data security" - why not?
Per this website: https://video2.skills-academy.com/en-us/analysis-services/tabular-models/hide-or-freeze-columns-ssas-tabular?view=asallproducts-allversions The ability to hide columns is not intended to be used for data security, only to simplify…
![](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(252.8, 39%, 34%)' 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)
1 answer
Tabular Model not processing in Azure AS
We're testing migrating existing SSAS Tabular models from on-prem to Azure AS, but I'm running into processing errors with the Azure AS model. Background Simply SSAS tabular model - compatibility level = SQL Server 2016 RTM (1200) Data…
asked 2022-09-21T06:03:59.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(265.6, 35%, 35%)' 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)
Scott Kent-Collins
1
Reputation point
commented 2022-09-29T01:11:35.563+00:00
KranthiPakala-MSFT
46,462
Reputation points Microsoft Employee
1 answer
Azure Analysis Service Tabular Model - TMSL Merge Partition script error
I am trying to merge existing table partition in Azure Analysis Service to main table using below TMSL script. { 'mergePartitions': { 'target': { 'database': 'AASDatabase', 'table': 'sales', …
asked 2022-09-15T17:06:20.407+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(156.8, 35%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Naveen Kumar
1
Reputation point
commented 2022-09-27T16:17:50.03+00:00
ShaikMaheer-MSFT
38,441
Reputation points Microsoft Employee