Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
454 questions
1 answer
During AAS refresh we have been facing issue stating "Additional error details: DM_GWPipeline_Gateway_CanceledError The operation failed due to an explicit cancellation"
The Error details is mentioned in the image.
asked 2023-10-09T17:58:09.5266667+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, 77%, 34%)' 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)
Agamoni Ghosh (IN)
20
Reputation points
commented 2023-10-19T09:07:54.75+00:00
PRADEEPCHEEKATLA-MSFT
89,816
Reputation points Microsoft Employee
3 answers
How to solve the error "Not Supported in DirectQuery 1400 Mode" in AAS
I imported data into AAS, then I changed the DirectQuery Mode is ON. With the opening file, it was okay. However, when I closed and re-opened the file, it showed the error as below. I cannot open the model or change anything. When reopening, the…
asked 2023-07-19T01:56:12.79+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(208, 90%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKT%3C/text%3E%3C/svg%3E)
Katie Tran
5
Reputation points
answered 2023-10-17T23:00:09.8533333+00:00
Katie Tran
5
Reputation points
1 answer
Process Data + Process Recalc a AAS via Azure Data factory
Hello everyone, I am currently refreshing the AAS model in full mode using the REST API called from ADF, but the processing time of some tables is quite large. I have read some methods to reduce processing time, including the ‘ProcessData Plus…
asked 2023-10-12T02:52:50.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(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-10-16T10:44:18.8433333+00:00
AnnuKumari-MSFT
32,991
Reputation points Microsoft Employee
1 answer
Analysis service over Power BI embeded
Hello, We experience performance problems with our current Power BI embeded capacity. We are currently running everything on our embeded capacity, but are looking into other solution to handle more users. By moving our data model to Azure Analysis…
asked 2023-10-11T09:42:59.88+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(297.6, 1%, 38%)' 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)
Mathias Pabst Lassen Andersen
10
Reputation points
commented 2023-10-13T16:18:26.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(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,271
Reputation points
1 answer
One of the answers was accepted by the question author.
Is caching entire Azure analysis services cube/model possible using Azure cache for Redis?
Hello, I am trying to access Azure analysis services Model data using web analytics. Due to huge data on AAS, It has performance issues. So wanted to know if we can cache entire cube/model data in redis cache to get faster response? if not how can we…
asked 2023-10-06T09:44:49.85+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, 67%, 14%)' 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)
Sulbha Mule (AVANADE INC)
25
Reputation points
commented 2023-10-13T06:10:50.5366667+00:00
Sulbha Mule (AVANADE INC)
25
Reputation points
1 answer
Dependency analysis for 2016 windows server not supported?
We will scan the VMware environment of the customer , In the documentation (VMWare Dependency analysis agentless) I saw for dependency analysis its not supported for 2016 servers. I was wondering why 2016 is not supported and 2019 is supported?
asked 2023-10-09T14:20:03.8866667+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(6.4, 53%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZK%3C/text%3E%3C/svg%3E)
Zeynep Kamali
80
Reputation points Microsoft Vendor
answered 2023-10-09T19:05:23.1966667+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
31,031
Reputation points Microsoft Employee
1 answer
Dynamics 365 User dataverse analytics refresh rate
Dear Azure Support, This monday we had a Go-live of our clients Dynamics 365 CE system. Now we would like to have an up-to-date User analytics. So, who has logged in etc. We found the D365 User Dataverse analytics but unfortunately the refresh rate is…
asked 2023-09-25T11:31:22.9633333+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, 97%, 28%)' 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)
Bram Boerman
0
Reputation points
commented 2023-10-09T05:02:58.7733333+00:00
AnnuKumari-MSFT
32,991
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Tabular VS Multidimensional - why the latter are not supported in Azure Analysis Services
I want to understand the differences between both and why the multidimensional models are not supported in AAS?
![](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, 16%, 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)
1 answer
GetConsoleWindow used in Microsoft.AnalysisServices.retail 19.67.0 causing issues in Mono
We have a C# program which uses TOM to synchronize an Analysis Services Model to individual Analysis Services instances on Azure. We have used this program for a few years now and run it daily for multiple servers on a Linux machine, using Mono. This…
asked 2023-10-06T12:24:02.4966667+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(89.60000000000001, 27%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFJ%3C/text%3E%3C/svg%3E)
Frits Jalvingh
0
Reputation points
answered 2023-10-06T18:38:39.87+00:00
Bhargava-MSFT
31,031
Reputation points Microsoft Employee
2 answers
Unable to connect SQL server to Azure ML pipeline?
Hi, I am trying to connect sql server using pyodbc and to extract some procedure for Azure ML pipeline. Since I am not able to install pyodbc library in Azure ML, pipeline connection is not happening. Kindly let me know is there any alternative method…
asked 2022-03-17T06:56:59.34+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(297.6, 82%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
MOHAMMED ABDULLA T
6
Reputation points
commented 2023-10-06T00:06:54.07+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(3.2, 72%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBC%3C/text%3E%3C/svg%3E)
Benjamin Carter
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Help me decide between Azure data lake analytics and Azure Databricks
Both Azure Data Lake Analytics and Azure Databricks can be used for batch processing. Can you help me understand for which case we can use each one?
![](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, 64%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
2 answers
Connection between Azure Analysis service and powerbi
Hello, I'm attempting to establish a connection between Azure Analysis Services and Power BI in Direct Query Mode. However, I'm encountering a challenge where the storage mode in the model is fixed as default, and I'm unable to switch it to dual storage…
asked 2023-09-30T05:43:35.3933333+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, 93%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
Nazim Abdul Rahman
0
Reputation points
commented 2023-10-04T06:34:57.7933333+00:00
QuantumCache
20,271
Reputation points
1 answer
Is there any way to trigger the backup in azure analysis services expext using powershell command. ?
I was trying to find programable way to trigger the backup AAS(azure analysis services). I got only one way which we need to use PowerShell script but unable to find another way to accomplish it. Could not be able to find any api call as to do same…
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
454 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,962 questions
asked 2023-09-05T22:02:31.9166667+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(230.39999999999998, 86%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPG%3C/text%3E%3C/svg%3E)
Praveen Gujja
0
Reputation points
commented 2023-10-03T09:21:21.0566667+00:00
ShaikMaheer-MSFT
38,451
Reputation points Microsoft Employee
1 answer
How to connect Azure sql database live with azure analysis services.
Hi, we are trying to connect Azure SQl database with azure Analysis services, but the data's are not connecting live. Is there any way to connect it live and i am using development pricing tier, is it needed to upgrade for live connection? Thanks, Hamna…
asked 2023-09-26T05:29:25.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(224.00000000000003, 96%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHK%3C/text%3E%3C/svg%3E)
Hamna KS
0
Reputation points
commented 2023-09-27T13:14:17.6433333+00:00
Amira Bedhiafi
25,261
Reputation points
2 answers
Azure Analysis Services - Tabular Visual Studio Deployment - The stream does not have an active operation!
Hello! When I needed to deploy my last model changes in Visual Studio for my AAS Tabular Mode. I have successfully deployed the model to AAS that afternoon. I get the following error: Cannot deploy metadata. Reason: An error occurred while connecting…
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 2023-09-21T17:28:20.46+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(243.2, 91%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
Liz Rogers
0
Reputation points
answered 2023-09-26T20:01:52.6066667+00:00
QuantumCache
20,271
Reputation points
1 answer
One of the answers was accepted by the question author.
I can't find the process feature in Visual Studio 2022
I can't find the process feature in Visual Studio 2022, it should be in the bar where the red line is.
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
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,285 questions
1 answer
Connecting Azure Analysis Services to an Azure SQL Database in real-time.
"Hello, I'd like to inquire about connecting Azure Analysis Services to an Azure SQL Database in real-time. Could you provide guidance on establishing a live connection between Azure Analysis Services and Azure SQL Database? Additionally, I'm…
asked 2023-09-26T08:43:27.96+00:00
Nazim Abdul Rahman
0
Reputation points
answered 2023-09-26T09:06:02.2833333+00:00
Amira Bedhiafi
25,261
Reputation points
1 answer
Not able to fetch token for tenant ID - Azure Analysis Service release pipeline deployment
Greetings! I'm working on a Azure Analysis Service project. We have multiple models in there and we are maintaining our codes in Azure Devops Repos. As of now, we are deploying our model to the server (both dev and production environment) manually…
asked 2023-09-18T16:41:13.34+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, 52%, 15%)' 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)
Thamarai Selvan T
0
Reputation points
answered 2023-09-20T19:29:57.8666667+00:00
Bhargava-MSFT
31,031
Reputation points Microsoft Employee
2 answers
SSAS refresh failure after upgrade from Tier S1 to S2 in Azure
Hello everyone., I am wondering if anyone has encountered this error and has found a feasible solution for it already. little bit of context: we are hosting SSAS cubes in Microsoft Azure services and after an upgrade from tier S1 Standard to S2…
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
454 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,031 questions
asked 2023-09-06T20:04:17.5966667+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(166.4, 49%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYP%3C/text%3E%3C/svg%3E)
Yamel Peraza
20
Reputation points
commented 2023-09-19T15:29:06.9+00:00
AnnuKumari-MSFT
32,991
Reputation points Microsoft Employee
1 answer
Cannot connect to Azure Analysis Services - The stream does not have an active operation
Suddenly my connection to Azure AS stopped working in SSMS. I get weird error that I cannot find any info about on Google: =================================== Error connecting to…
asked 2023-09-14T15:07:49+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(99.2, 34%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mandík, Michael (Adastra Corporation)
5
Reputation points
answered 2023-09-14T16:07:37.93+00:00
Vinodh247
21,881
Reputation points