Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
444 questions
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
![](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,261
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.
444 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,642 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,401
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
19,946
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.
444 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,883 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,261
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.
444 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,883 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,263 questions
![](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
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
19,946
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
![](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
29,036
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.
444 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,079 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,161
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
13,626
Reputation points
1 answer
One of the answers was accepted by the question author.
Cannot find API's to extract Azure Analysis Model Data
I am reaching out here for guidance and assistance with a unique challenge I am facing in accessing Azure Analysis Model data. Despite the absence of a dedicated API in the official Azure documentation, I am seeking a way to extract this data and…
asked 2023-08-30T15:57:38.77+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, 34%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Anil Thota
20
Reputation points
commented 2023-09-05T15:16:40.26+00:00
Anil Thota
20
Reputation points
1 answer
The gateway did not receive a response from 'Microsoft.AnalysisServices' within the specified time period.
Hello, I'm not able to scale-up our AAS server from S2 to S4. It was working until last night integration and processing batch. Could someone help me with this issue please ? Kind regards, Mohammad PATEL
asked 2023-08-26T05:02:55.8433333+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(12.8, 95%, 11%)' 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)
Mohammad PATEL
0
Reputation points
commented 2023-09-04T07:06:17.3766667+00:00
PRADEEPCHEEKATLA-MSFT
85,511
Reputation points Microsoft Employee
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(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-09-01T22:52:06.9533333+00:00
QuantumCache
20,261
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
32,161
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
Bhargava-MSFT
29,036
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
19,946
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,442
Reputation points Microsoft Employee