Microsoft Q&A

Azure Analysis Services

361 questions

An Azure service that provides an enterprise-grade analytics engine.

Browse all Azure tags

361 questions with Azure Analysis Services tags

Sort by: Updated
1 answer

Tabular model creates two databases using visual studio

Hello Experts, When I use the visual studio to deploy my tabular model it creates two databases. It looks like both databases have the exact same copies. I am not sure which one to use. Can you give me some insights on this. Do we know why there two…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
361 questions
asked 2023-06-02T14:19:31.4266667+00:00
ChoudaryR-6454 40 Reputation points
commented 2023-06-05T16:21:25.73+00:00
BhargavaGunnam-MSFT 13,656 Reputation points Microsoft Employee
0 answers

How to deploy and refresh tabular model with AAD datasource

I have a customer looking to deploy an Azure Analysis Services (AAS) tabular model using Azure DevOps. However the underlying database is a Synapse Lake Database which does not support SQL authentication. All the examples seem to be for sql auth. They…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
361 questions
asked 2023-06-05T09:04:34.8566667+00:00
Damien O'Connor 0 Reputation points Microsoft Employee
2 answers

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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
361 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,101 questions
asked 2023-05-03T21:04:59.8266667+00:00
swabhiman das 0 Reputation points
commented 2023-06-02T08:29:21.25+00:00
PercyTang-MSFT 5,626 Reputation points Microsoft Vendor
1 answer

Azure Analysis Services S9 pricing tier is missing

Hi , I had recently upgraded the pricing tier of my Azure analysis services from S9 to S9v2 to check the performance. Since S9v2 incurs more cost , i wanted to scale down back to S9. But now the S9 pricing tier is not at all available in Azure portal…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
361 questions
asked 2023-05-18T05:28:38.3466667+00:00
Binu Joseph (MINDTREE LIMITED) 0 Reputation points Microsoft Vendor
commented 2023-05-31T00:28:31.39+00:00
BhargavaGunnam-MSFT 13,656 Reputation points Microsoft Employee
1 answer

How to stop cube processing that was triggered from ADF web activity

I have created ADF pipeline to process tabular model in AAS using web activity (By referring the url https://github.com/furmangg/automating-azure-analysis-services/blob/master/ADFv2/ProcessAzureAS.json). As web activity is an asynchronous call to process…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
361 questions
asked 2023-05-08T15:31:09.4533333+00:00
Poornima 21 Reputation points
commented 2023-05-29T13:37:10.18+00:00
ShaikMaheer-MSFT 31,806 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

processing aas tabular model in visual studio results in two tabular databases with a model in each

Hi, when i build, deploy and process my Azure Analysis Services Tabular Model in Visual Studio and connect PowerBI to it, i always see two Tabular Databases. One has the normal expected name and the other one has a string attached to it. It looks like a…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
361 questions
asked 2023-05-24T14:46:20.19+00:00
Gökhan Demirci 40 Reputation points
accepted 2023-05-29T10:04:43.55+00:00
Gökhan Demirci 40 Reputation points
0 answers

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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
361 questions
asked 2022-10-18T20:09:24.9+00:00
S79 6 Reputation points
commented 2023-05-23T10:45:49.4233333+00:00
Strategic BI 0 Reputation points
1 answer One of the answers was accepted by the question author.

Criar partições no modelo do Azure Analysis Services via SMSS

Estou tentando criar partições de uma tabela usando o modelo do Azure Analysis Services, porém me retorna o seguinte erro: " Failed to save modifications to the server. Error returned: 'An error occurred during On-Premise Gateway related activity.…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
361 questions
asked 2023-05-12T18:50:55.65+00:00
Loren Rana da Silva Oliveira 21 Reputation points
accepted 2023-05-22T15:11:27.5966667+00:00
Loren Rana da Silva Oliveira 21 Reputation points
2 answers

SQL Auth for AAS

We have an azure analysis service with firewall enabled. So to refresh a powerbi report, accessing AAS I need a gateway. We have MFA enabled on our accounts so we are unable to set up the gateway. So is there are any other way like SQL accounts…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
361 questions
asked 2022-04-14T12:23:12.71+00:00
Sahil Mehta 61 Reputation points
answered 2023-05-19T05:16:06.9133333+00:00
Nandan Hegde 22,721 Reputation points
1 answer

Copy data from AAS via ADF

I have a requirement wherein I need to copy data from AAS via ADF and I am following the below blog : https://datasharkx.wordpress.com/2021/03/16/copy-data-from-ssas-aas-through-azure-data-factory/ But we have a scenario wherein we have MFA…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
361 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,177 questions
asked 2021-11-11T03:32:19.343+00:00
Sahil Mehta 61 Reputation points
answered 2023-05-19T05:14:20.5566667+00:00
Nandan Hegde 22,721 Reputation points
0 answers

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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
361 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,101 questions
asked 2023-04-09T22:45:32.19+00:00
Syed Shah 0 Reputation points
commented 2023-05-18T19:05:13.1766667+00:00
Karyani Karyani 0 Reputation points
1 answer One of the answers was accepted by the question author.

Can't connect to azure analysis services with python and azure function using azure active directory.

Hi, iam trying to connect azure analysis services to query a tabular model using an azure function which is coded with python. The authorization is working through azure active directory and i setup oauth in my python script with token requests. The…

Azure Cloud Services
Azure Cloud Services
An Azure platform as a service offer that is used to deploy web and cloud applications.
512 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
3,026 questions
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
361 questions
asked 2023-05-10T12:15:18.22+00:00
Gökhan Demirci 40 Reputation points
accepted 2023-05-17T10:17:13.6933333+00:00
Gökhan Demirci 40 Reputation points
2 answers

Installing on-premise-data-gateway on Azure Virtual machine

We need to install on-premise-data-gateway on Azure Virtual machine (VM) and mainly while configuring which instance of Azure Virtual machine (VM) is preferred.

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
5,273 questions
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
361 questions
asked 2020-09-07T10:44:22.67+00:00
Vamshi Kishore KALIKOTA 41 Reputation points
commented 2023-05-12T14:20:27.7433333+00:00
Pradeep Raju 1 Reputation point
1 answer

IP Address whitelisting in Azure Analysis Services for ADF SSIS-IR

We have the following simplified resources setup in Azure. There are SSIS pkgs which deploys and processes tabular models .bim files as XMLA scripts to AAS. The Firewall has been enabled in the AAS and the IP address of the SSIS IR is whitelisted. …

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,177 questions
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
361 questions
asked 2023-04-25T09:57:50.5333333+00:00
Subash Basnayake 46 Reputation points
answered 2023-05-02T21:34:05.9+00:00
BhargavaGunnam-MSFT 13,656 Reputation points Microsoft Employee
1 answer

Is there an Azure SaaS or Plugin with WYSIWYG for building SQL queries and reports?

I am looking for SaaS solution to allow my end users to access and query their SQL data, to create BI charts and reports, etc. However, it must have a solution for complete SQL Illiterates (WYSIWYG). I found something called DataPine which is located in…

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,101 questions
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
361 questions
asked 2023-04-26T15:54:56.7+00:00
Milan Polak 0 Reputation points
edited the question 2023-05-01T02:32:28.7833333+00:00
PercyTang-MSFT 5,626 Reputation points Microsoft Vendor
1 answer

Conversion overflows error in Analysis Services (Tabular)

Analysis Data Model Processing Failure.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
361 questions
asked 2023-04-12T19:38:33.83+00:00
Akinjide Akinwale 0 Reputation points
commented 2023-04-19T08:16:11+00:00
PRADEEPCHEEKATLA-MSFT 59,336 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Building a Data Dictionary for a Tabular Model

I used to have some SQL Server queries I could use to create a bus matrix & data dictionary from my old MDX cube through a linked server. We are now using Tabular Models in Azure Analysis Services and I was wondering if there are a similar set of…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
361 questions
asked 2023-04-12T11:32:24.1133333+00:00
Andrew Blyth 20 Reputation points
accepted 2023-04-18T09:44:48.19+00:00
Andrew Blyth 20 Reputation points
1 answer

How to ensure that my AAS tabular model is using AAS server processing power and not local system processing power while refreshing/processing the model?

Hi , We have created a tabular model using visual studio for 8 million records currently which took 2 hours. We have around 200-300 million records for which we want to create the tabular model to perform some load testing. What is the best way to create…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
361 questions
asked 2023-04-05T07:57:02.3566667+00:00
Aishwarya Shirsathe 0 Reputation points
commented 2023-04-10T08:14:48.94+00:00
PRADEEPCHEEKATLA-MSFT 59,336 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Migrate dimensions in cubes to tabular

Hi Experts, I'm trying to replicate multidimensional cubes in tabular in order to deploy them on Azure. Now I'm trying to re-create the hierarchies in each view. In tabular each hierarchy level has a source column, does it correspond to Key Column or…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
361 questions
asked 2023-04-03T01:26:57.7533333+00:00
何思达 20 Reputation points
accepted 2023-04-10T01:39:44.15+00:00
何思达 20 Reputation points
1 answer

How to process data from sql server to azure analysis service without getting timeout?

Hello! Every day, I need to process data from SQL Server to Azure Analysis Services (which I use as a data source for my Power BI report). I have set up a runbook in Azure that uses a PowerShell script to accomplish this. I followed this tutorial:…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
361 questions
asked 2023-03-30T09:45:37.5033333+00:00
Thor 1 Reputation point
commented 2023-04-03T04:54:20.2666667+00:00
PRADEEPCHEEKATLA-MSFT 59,336 Reputation points Microsoft Employee