Microsoft Q&A

Azure Analysis Services

347 questions

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

Browse all Azure tags

347 questions with Azure Analysis Services tags

Sort by: Updated
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.
347 questions
asked 2023-03-30T09:45:37.5033333+00:00
Thor 1 Reputation point
edited the question 2023-03-31T01:27:35.8233333+00:00
Seeya Xi-MSFT 15,196 Reputation points Microsoft Vendor
1 answer

Azure Analysis Services tabular model for 50 GB Data (Approx 99 Million Records))

looking for recommendation to deploy 50 GB Data in Synapse Analytics (Approx 99 Million Records), Please suggest if Azure Analysis services S0 is capable of deploying and processing this volume of data.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
347 questions
asked 2023-03-22T12:37:27.9533333+00:00
Abhijeet Kumar 0 Reputation points
commented 2023-03-30T19:44:18.0466667+00:00
HimanshuSinha-msft 18,621 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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
347 questions
asked 2022-03-17T06:56:59.34+00:00
MOHAMMED ABDULLA T 1 Reputation point
answered 2023-03-27T20:57:16.32+00:00
Thiago Barral 0 Reputation points
1 answer One of the answers was accepted by the question author.

Azure Log Search API to Grab Information

Hello, Thanks ahead of time for any information you can provide. What I am attempting to do is this. I have a custom query that grabs the heal status of our vm. The in that query results i have the vms information like it if is health or unhealthy so…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
347 questions
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
4,934 questions
Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
385 questions
Azure Metrics Advisor
Azure Metrics Advisor
An Azure artificial intelligence analytics service that proactively monitors metrics and diagnoses issues.
69 questions
asked 2023-03-24T20:21:10.3366667+00:00
LaVar Blalock 25 Reputation points
commented 2023-03-27T01:46:50.27+00:00
kobulloc-MSFT 13,786 Reputation points Microsoft Employee
1 answer

After cloning from Git the analsys tabler modle not showing the Tabular model explorer

Hi expert I am able to create Git Repo after downloading the cube from server Below is the options available but after cloning the Repo I am not able to see the Tabular Model Explorer even I tried to enable the from View --> other windows --->…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
347 questions
asked 2023-02-24T12:20:32.3366667+00:00
Hazarath Reddy Boreddy 1 Reputation point
commented 2023-03-08T22:18:49.73+00:00
KranthiPakala-MSFT 36,017 Reputation points Microsoft Employee
0 answers

API pull of Azure Analysis Service Last modified time

I am trying to extract the highlighted value from a Azure Analysis Service. Looking at the regular API, this value is not available: GET…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
347 questions
asked 2023-02-26T15:11:23.17+00:00
Lily 1 Reputation point
commented 2023-03-08T07:43:43.5466667+00:00
PRADEEPCHEEKATLA-MSFT 56,551 Reputation points Microsoft Employee
0 answers

Model (Bim files) repointing from Gen1 datalake in AAS to Gen2 datalake

Hi, I have around 30 models in AAS which are currently pointing to Gen1 datalake. I would like to repoint them to Gen2 datalake with minimum efforts. Is there any utility for the same?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
347 questions
asked 2023-02-28T15:12:12.65+00:00
Erika Gupta 0 Reputation points
commented 2023-03-06T15:33:36.08+00:00
Amira Bedhiafi 151 Reputation points
0 answers

Namespace error in Azure Function

I am trying to query Azure Analysis Services through Azure Synapse. As there is no connector to do so directly, I used Azure function to connect to AAS. But I am getting the below error: [Error] run.csx(7,17): error CS0234: The type or namespace name…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
347 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
2,812 questions
asked 2023-03-02T16:54:12.89+00:00
Mohit Pawar 0 Reputation points
commented 2023-03-06T10:12:42.53+00:00
Mohit Pawar 0 Reputation points
0 answers

How to pass values from lookup activity to Web activity in azure data factory

Hi, I am attempting to refresh an Azure analysis using Azure Data Factory. When I use hard-coded values for the table name and partition name in the Web activity, the pipeline runs successfully. When I use a For Each activity to iterate through a list…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,721 questions
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
347 questions
asked 2023-02-28T14:09:48.87+00:00
muhammad abubakar 0 Reputation points
commented 2023-03-03T23:30:43.1466667+00:00
KranthiPakala-MSFT 36,017 Reputation points Microsoft Employee
1 answer

How to incrementally refresh Azure Analysis Services having synapse pool as source. Does “Default” processing option supports incremental refresh

Cube: Tabular (Azure Analysis Server)--- Source DB: Azure Synapse Pool --- Data Operation: Insert and update is happening on the source system Issue: Not able to get latest data from synapse pool in AAS cube, using "Default" processing…

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.
2,884 questions
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
347 questions
asked 2021-01-29T18:41:35.153+00:00
Vipul Singh 21 Reputation points
commented 2023-02-21T12:31:58.6966667+00:00
Kim Beck 0 Reputation points
0 answers

Azure Analytics software audit - list of registry entries checked

A quick background summary to put this query into context. Our cyber insurance requires that there is no (manufacturer/supplier/third party) unsupported software on any of our 1000+ servers. I have run an Azure Analytics query to search for 3…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
347 questions
asked 2023-02-10T11:49:26.8+00:00
Duckfield, Sam D 0 Reputation points
commented 2023-02-15T11:37:09.3166667+00:00
ShaikMaheer-MSFT 30,426 Reputation points Microsoft Employee
2 answers

Azure Analysis Services - error when processing blob storage data

Hello, I'm facing an issue regarding access to Blob Storage Container from Azure Analysis Server Instance. I've created a tabular model that pulls the data from Blob Container, but when I'm trying to process the data from the container in SQL Server…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
347 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
1,545 questions
asked 2021-10-01T12:44:18.527+00:00
Matthew 121 Reputation points
edited an answer 2023-02-11T00:05:00.36+00:00
Yan Linn Naing 0 Reputation points
0 answers

Can we convert R script to M code (Power Query)

As we are having few scripts in R which we are consuming in another scope, as per the new scope that needs be migrated to M (Power Query). If so, are there any best practices to migrate existing scripts to M code. Do we have any tools that can be used…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
347 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,721 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.
2,884 questions
asked 2023-01-27T12:38:18.8+00:00
Manohar Kondragunta 0 Reputation points
commented 2023-02-10T04:27:15.64+00:00
AnnuKumari-MSFT 21,406 Reputation points Microsoft Employee
2 answers

Composite SLAs

All, This is a very generic question. The below link talks about SLAs and how to arrive at Composite SLAs. Is multiplying percentages even the right way to arrive @ a Composite SLA for an application? …

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
347 questions
asked 2020-10-12T04:40:28.657+00:00
grajee 331 Reputation points
edited the question 2023-02-09T05:32:53.95+00:00
PRADEEPCHEEKATLA-MSFT 56,551 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.
347 questions
asked 2023-01-31T07:05:06.5666667+00:00
MAHESWAR KESS 0 Reputation points
commented 2023-02-06T19:01:37.1366667+00:00
BhargavaGunnam-MSFT 10,646 Reputation points Microsoft Employee
3 answers

Azure Analysis Services - Unable to delete an existing database using SSMS

Hi All, I have a database in analysis server which I want to delete completely. I guess that the database is corrupted somehow as I'm not able to connect that model to powerbi or do any operation on that model (simple operations too..for instance…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
347 questions
asked 2022-10-29T15:06:10.857+00:00
D U Maheswara Rao 1 Reputation point
answered 2023-02-03T13:43:36.4066667+00:00
Sanjaykumar Gajwani 0 Reputation points
1 answer

How to export list of dependencies from a tabular cube?

I have my cube already deployed: I am looking to map the dependencies of the cube; that is, the name of tables / data objects being used in these cubes. How can I output that list?? I would like to get the full list of all the sources like:

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
347 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,061 questions
asked 2023-01-23T13:45:38.91+00:00
ovonemty 21 Reputation points
edited the question 2023-02-02T11:02:48.2866667+00:00
PRADEEPCHEEKATLA-MSFT 56,551 Reputation points Microsoft Employee
0 answers

How to create a gateway from azure analysis server to on prem server? The azure analysis server is getting data from on-prem server but it is not working as expected.

How to create a gateway from azure analysis server to on prem server? The azure analysis server is getting data from on-prem server but it is not working as expected. While refreshing any tables inside the cube, its throwing error.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
347 questions
asked 2023-01-23T12:30:58.8433333+00:00
Kumar, PPrabhat 1 Reputation point
commented 2023-01-27T05:17:14.58+00:00
PRADEEPCHEEKATLA-MSFT 56,551 Reputation points Microsoft Employee
2 answers

Unable to upgrade tabular level to compatibility level to 1500

We are in the midst of upgrading our tabular models compatibility level to 1500. They are currently on 1200 and they are on SSAS not Azure Analysis Services. We were successful in converting most of them to 1500 and deploy them.. However, we are not able…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
347 questions
asked 2020-05-20T15:20:30.617+00:00
Nama, Srikanth 1 Reputation point
edited the question 2023-01-24T18:19:01.5466667+00:00
KranthiPakala-MSFT 36,017 Reputation points Microsoft Employee
0 answers

Use last interactive login profile to connect to Azure Analysis Service with Adomd client

I successfully connected to my org AAS database with Adomd .NET client library using Microsoft.AnalysisServices.AdomdClient; Console.WriteLine("Starting program..."); AdomdConnection adomdConnection = new…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
347 questions
asked 2022-12-22T01:10:19.347+00:00
Huy Nguyen 21 Reputation points
edited the question 2023-01-24T04:00:30.0633333+00:00
KranthiPakala-MSFT 36,017 Reputation points Microsoft Employee