431 questions with Azure Analysis Services tags

Sort by: Updated
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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 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,239 questions
asked 2023-04-09T22:45:32.19+00:00
Syed Shah 0 Reputation points
commented 2023-08-22T16:52:56.36+00:00
BhargavaGunnam-MSFT 24,726 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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2022-10-18T20:09:24.9+00:00
S79 6 Reputation points
answered 2023-08-17T13:10:23.1666667+00:00
Amira Bedhiafi 12,791 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…

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,267 questions
asked 2023-08-10T08:28:41.3766667+00:00
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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Azure Firewall
Azure Firewall
An Azure network security service that is used to protect Azure Virtual Network resources.
555 questions
asked 2023-08-11T11:12:23.82+00:00
Muhammad Hammad Naeem 45 Reputation points
answered 2023-08-14T23:43:54+00:00
KranthiPakala-MSFT 46,412 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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 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,239 questions
asked 2021-10-14T14:03:29.63+00:00
Yor Braakman 6 Reputation points
answered 2023-08-06T12:04:50.77+00:00
Amira Bedhiafi 12,791 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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2023-07-25T16:37:18.93+00:00
Andy 1 Reputation point
answered 2023-07-26T05:26:28.2766667+00:00
PRADEEPCHEEKATLA-MSFT 74,641 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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,213 questions
asked 2023-07-19T10:21:43.7766667+00:00
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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2023-07-14T15:29:47.13+00:00
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

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
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…

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2023-07-10T13:23:10.4766667+00:00
Cabral, Scott 21 Reputation points
edited the question 2023-07-21T09:28:39.14+00:00
Tianyu Sun-MSFT 25,871 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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
1,921 questions
asked 2023-07-14T05:20:03.63+00:00
Rajmohan Ponnurangam 0 Reputation points
edited an answer 2023-07-20T18:46:58.54+00:00
BhargavaGunnam-MSFT 24,726 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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2023-07-14T16:58:25.4833333+00:00
Jaganathan, NK. (Naveen Kumar) 0 Reputation points
commented 2023-07-20T16:52:23.22+00:00
ShaikMaheer-MSFT 37,486 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?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2023-07-11T18:55:45.94+00:00
Richard Duane Wolford Jr 196 Reputation points
answered 2023-07-11T21:27:59.5766667+00:00
SaBo-MSFT 20,016 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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2023-06-21T14:51:29.4133333+00:00
JKmag-8992 0 Reputation points
commented 2023-07-10T06:09:20.29+00:00
PRADEEPCHEEKATLA-MSFT 74,641 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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,084 questions
asked 2023-06-14T05:41:23.8233333+00:00
Shounak Mukund Sangli 0 Reputation points
commented 2023-07-06T12:06:29.1466667+00:00
SwathiDhanwada-MSFT 16,966 Reputation points
1 answer

Processing Of Azure Analysis Server Failed

Hi, we are trying to refresh the azure analysis server using the Azure Logic apps. While I am trying to process i am getting the following error Error Details<br/><p style='color:red'>[{"message":"Retry attempts for failures…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,750 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,402 questions
asked 2023-06-30T13:01:37.0666667+00:00
MAHESWAR KESS 0 Reputation points
answered 2023-07-03T21:06:31.3+00:00
BhargavaGunnam-MSFT 24,726 Reputation points Microsoft Employee
1 answer

Processing Of Azure Analysis Server Failed

we are trying to refresh the azure analysis server using the Azure Logic apps. While I am trying to process i am getting the following error. {"message":"Retry attempts for failures while executing the refresh exceeded the retry limit set…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2023-01-31T07:05:06.5666667+00:00
MAHESWAR KESS 0 Reputation points
commented 2023-06-30T16:03:03.4766667+00:00
BhargavaGunnam-MSFT 24,726 Reputation points Microsoft Employee
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 Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Azure Cloud Services
Azure Cloud Services
An Azure platform as a service offer that is used to deploy web and cloud applications.
623 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,076 questions
asked 2023-05-10T12:15:18.22+00:00
Gökhan Demirci 40 Reputation points
commented 2023-06-23T09:02:50.5633333+00:00
SADHANA ALUGURI, GFPD 0 Reputation points
0 answers

How to transform D365F&O data before connecting to power BI from synapses

Hi , I have created view in Azure synapses using CDMUtilSolution for data's exported from D365 F&O . Please help me understand how can I transform these data's and model this data in a better and cost effective way before loading and transforming…

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,579 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,213 questions
asked 2023-06-16T09:03:29.9733333+00:00
Athira Reghuraman 60 Reputation points
edited the question 2023-06-19T14:41:46.4133333+00:00
MuthuKumaranMurugaachari-MSFT 21,971 Reputation points
1 answer

Azure Analysis Services with Power BI Architecture

Hello, We have around 50 power bi reports connected Live to On-Premise Analysis Services, and we are migrating to Azure Analysis Services. When it was on premise it didn't matter if it was Live or import because we are were not charged by hour or…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2023-06-10T11:39:16.76+00:00
John Elmasry 0 Reputation points
commented 2023-06-12T05:56:51.2533333+00:00
John Elmasry 0 Reputation points